SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<< PHP and MySQL syntax Steps for SQL syntax debug * Reduce the complexity of SQL syntax ex: reduce the {{ kbd | key = WHERE }} condition * Writing log more on Testing...") |
No edit summary |
||
| Line 1: | Line 1: | ||
<< [[PHP and MySQL syntax]] | How to debug SQL query syntax << [[PHP and MySQL syntax]] | ||
| Line 7: | Line 7: | ||
* Using the tool for syntax highlight ex: Using the [http://www.sublimetext.com/ Sublime], and enable the Menu option: {{ kbd | key = View > Syntax >SQL }} | * Using the tool for syntax highlight ex: Using the [http://www.sublimetext.com/ Sublime], and enable the Menu option: {{ kbd | key = View > Syntax >SQL }} | ||
tools | |||
* Using [http://www.sublimetext.com/ Sublime Text]. Menu: View -> Syntax -> SQL. The syntax will become colorful for easy to read! | |||
[[Category:Programming]] [[Category:MySQL]] | [[Category:Programming]] [[Category:MySQL]] | ||
Revision as of 15:48, 14 May 2015
How to debug SQL query syntax << PHP and MySQL syntax
Steps for SQL syntax debug
- Reduce the complexity of SQL syntax ex: reduce the WHERE condition
- Writing log more on Testing#Database_server
- Using the tool for syntax highlight ex: Using the Sublime, and enable the Menu option: View > Syntax >SQL
tools
- Using Sublime Text. Menu: View -> Syntax -> SQL. The syntax will become colorful for easy to read!