SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
m
→Approach 1: Reduce the complexity of Sql query
Tags: Mobile edit Mobile web edit |
Tags: Mobile edit Mobile web edit |
||
Line 7: | Line 7: | ||
* Examine the sub query part only | * Examine the sub query part only | ||
* Enable the MySQL server log contains each query or errors. Details on [[Testing#Database_server]] | * Enable the MySQL server log contains each query or errors. Details on [[Testing#Database_server]] | ||
* Disable unnecessary database operation | * Disable unnecessary permission of database operation | ||
== Approach 2: Using MySQL syntax checker == | == Approach 2: Using MySQL syntax checker == |