SQL syntax debug: Difference between revisions

Jump to navigation Jump to search
no edit summary
No edit summary
No edit summary
Line 9: Line 9:
* Enable the MySQL server log. Details on [[Testing#Database_server]]
* Enable the MySQL server log. Details on [[Testing#Database_server]]
* Disable unnecessary database operation permission
* Disable unnecessary database operation permission
* 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!
* Beautify the sql syntax e.g.
** 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]


MySQL server configuration
MySQL server configuration

Navigation menu