Tag Archives | MYSQL

MYSQL: How to DELETE with INNER JOIN

MYSQL: How to DELETE with INNER JOIN There are 2 tables, proxy and proxy2, and I need to delete data from proxy. proxy.md5 = proxy2.md5 is the only thing that “connect” the tables. I have tried this script but it doesn’t work: Result: #1064 – You have an error in your SQL syntax; check the […]

Read full story Comments { 0 }
How to install mytop

How to install mytop

mytop is a ‘top’ clone for MySQL. mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL 3.22.x, 3.23.x, and 4.x servers. It runs on most Unix systems which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. As of version 0.7, it even runs […]

Read full story Comments { 0 }