14,953
edits
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 | ||
* | * 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 | ||