SQL syntax debug: Difference between revisions

SQL syntax debug (edit)

284 bytes added , 28 April 2017

no edit summary

14,953

edits

@@ Line 1: / Line 1: @@
 How to debug MySQL query syntax
-Goal:
+== Approach 1: Reduce the complexity of Sql query ==
-* Reduce the complexity
 Steps:
@@ Line 9: / Line 8: @@
 * Enable the MySQL server log. Details on [[Testing#Database_server]]
 * 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!
+== Approach 2: Using MySQL syntax checker ==
-** [http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]
+* [https://www.mysql.com/products/workbench/ MySQL :: MySQL Workbench]
+* More on [https://www.quora.com/Where-can-I-find-a-good-MySQL-syntax-checker Where can I find a good MySQL syntax checker? - Quora]
+== Approach 3: Beautify the Sql syntax ==
+* 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