MySQL slow query log records sql statements that are taking too much time to execute. Enabling and analyzing of this log can be very helpful in knowing the cause of slow mysql server.
Learn how to get only those records from a resultset that have their duplicate records. Learn to write SQL statement that can fetch you such a result.
Learn how to take backup of a MySQL table by dumping it into a simple text file. The file can also be restored into a database whenever needed.
Learn how to create a table in mysql with a name passed on as a parameter. This may be useful when you need to create tables using stored procedures.
Here are a few useful MySQL commands for common routine work related with database management. I keep these statements on my desk as a quick reference guide.