Just came across this great article with 20 best practices when using MySQL: MySQL best practices.
Be sure to check them, the following items are in the article:
Optimize Your Queries For the Query Cache
LIMIT 1 When Getting a Unique Row
Get Suggestions with PROCEDURE ANALYSE()
Prepared Statements
Split the Big DELETE or INSERT Queries
Be Careful with Persistent Connections
And more [...]
Today I was playing around with some MySQL statements, because I ran into a problem that I wanted to list my database tables.
I found out about the MySQL SHOW statements, and I’ve found out that they can be very usefull!
That why I will describe some of the usefull ways to use the SHOW [...]