SQL syntax debug: Difference between revisions

Jump to navigation Jump to search
70 bytes removed ,  8 June 2015
no edit summary
No edit summary
No edit summary
Line 4: Line 4:
Steps for SQL syntax debug
Steps for SQL syntax debug
* 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
* Writing log more on [[Testing#Database_server]]
* Enable the MySQL server log. Details on [[Testing#Database_server]]
* 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 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!


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]]

Navigation menu