SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary Tags: Mobile edit Mobile web edit |
||
| Line 14: | Line 14: | ||
== Approach 3: Beautify the Sql syntax == | == Approach 3: Beautify the Sql syntax == | ||
Beautify the SQL syntax for better readability. | |||
* Using the text editor [http://www.sublimetext.com/ Sublime], and enable the Menu option: {{ kbd | key = View > Syntax >SQL }}. The syntax will become colorful for easy to read! | * Using the text editor [http://www.sublimetext.com/ Sublime], and enable the Menu option: {{ kbd | key = View > Syntax >SQL }}. The syntax will become colorful for easy to read! | ||
* [http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter] | * [http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter] | ||
== Related articles == | |||
MySQL server configuration | MySQL server configuration | ||
* [http://mysqltuner.com/ MySQLTuner-perl by major] | * [http://mysqltuner.com/ MySQLTuner-perl by major] | ||
Revision as of 10:58, 30 April 2017
How to debug MySQL query syntax
Approach 1: Reduce the complexity of Sql query
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
Approach 2: Using MySQL syntax checker
Approach 3: Beautify the Sql syntax
Beautify the SQL syntax for better readability.
- 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
Related articles
MySQL server configuration
Further reading
- Craig Kerstiens (2016). Writing more legible SQL [Last visited: 2016-11-03]