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