SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
m
→Approach 1: Reduce the complexity of Sql query
| Line 6: | Line 6: | ||
* Reduce the complexity of SQL syntax e.g. remove the {{ kbd | key = WHERE }} condition | * Reduce the complexity of SQL syntax e.g. remove the {{ kbd | key = WHERE }} condition | ||
* Examine the query result of subqueries | * Examine the query result of subqueries | ||
* Enable the MySQL server log contains each query or errors. Details on [[Testing#Database_server]] | * (optional) Enable the MySQL server log contains each query or errors. Details on [[Testing#Database_server]] | ||
* Disable unnecessary permission of database operation | * Disable unnecessary permission of database operation | ||