SQL syntax debug

How to debug MySQL query syntax

Goal:

• Reduce the complexity

Steps:

• Reduce the complexity of SQL syntax ex: reduce the WHERE condition
• Examine the sub query part only
• Enable the MySQL server log. Details on Testing#Database_server
• Disable unnecessary database operation permission
• Using the syntax highlight tool ex: Using the Sublime, and enable the Menu option: View > Syntax >SQL. The syntax will become colorful for easy to read!

MySQL server configuration

• MySQLTuner-perl by major