SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
* Enable the MySQL server log. Details on [[Testing#Database_server]] | * Enable the MySQL server log. Details on [[Testing#Database_server]] | ||
* Using the syntax highlight tool ex: Using the [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 syntax highlight tool ex: Using the [http://www.sublimetext.com/ Sublime], and enable the Menu option: {{ kbd | key = View > Syntax >SQL }}. The syntax will become colorful for easy to read! | ||
MySQL server configuration | |||
* [http://mysqltuner.com/ MySQLTuner-perl by major] | |||
[[Category:Programming]] [[Category:MySQL]] | [[Category:Programming]] [[Category:MySQL]] | ||
Revision as of 13:53, 2 October 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!
MySQL server configuration