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
• Beautify the sql syntax e.g.
  • Using the text editor Sublime, and enable the Menu option: View > Syntax >SQL. The syntax will become colorful for easy to read!
  • Instant SQL Formatter

MySQL server configuration

• MySQLTuner-perl by major

Further reading

• Craig Kerstiens (2016). Writing more legible SQL [Last visited: 2016-11-03]