SQL syntax debug

From LemonWiki共筆

Revision as of 10:56, 8 June 2015 by Planetoid (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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
Enable the MySQL server log. Details on Testing#Database_server
Using the syntax highlight tool ex: Using the Sublime, and enable the Menu option: View > Syntax >SQL. The syntax will become colorful for easy to read!

Retrieved from "https://wiki.planetoid.info/index.php?title=SQL_syntax_debug&oldid=15115"