SQL syntax debug: Difference between revisions

Revision as of 11:18, 26 August 2016

How to debug MySQL query syntax

Goal:

Steps:

Reduce the complexity of SQL syntax ex: reduce the WHERE condition
Examine the sub query part only
Enable the MySQL server log. Details on Testing#Database_server
Disable unnecessary database operation permission
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!

MySQL server configuration

Revision as of 11:18, 26 August 2016 (edit) Planetoid (talk \| contribs) No edit summary ← Older edit		Revision as of 11:18, 26 August 2016 (edit) (undo) Planetoid (talk \| contribs) No edit summary Newer edit →
Line 15:		Line 15:


	[[Category:Programming]] [[Category:MySQL]]		[[Category:Programming]] [[Category:MySQL]] [[Category:Data Science]]