SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
* Reduce the complexity of SQL syntax ex: reduce the {{ kbd | key = WHERE }} condition | * Reduce the complexity of SQL syntax ex: reduce the {{ kbd | key = WHERE }} condition | ||
* Enable the MySQL server log. Details on [[Testing#Database_server]] | * Enable the MySQL server log. Details on [[Testing#Database_server]] | ||
Revision as of 10:53, 9 June 2015
How to debug SQL query syntax << PHP and MySQL syntax
- Reduce the complexity of SQL syntax ex: reduce the WHERE condition
- Enable the MySQL server log. Details on Testing#Database_server
- 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!