MySQL Bugs: #17195: Syntax check for SQL scripts

Bug #17195	Syntax check for SQL scripts
Submitted:	7 Feb 2006 15:53	Modified:	6 Mar 2006 12:48
Reporter:	Kai Ruhnau	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	all	OS:	Linux (Gentoo Linux)
Assigned to:		CPU Architecture:	Any

Description:
It would be very helpful for me to have a program/option to run a syntax check over SQL files.

I often have several handcrafted DDL statements in one file and one or the other might have syntax errors. When I try to integrate these changes in my test system, syntax errors (as well as semantic errors) let the processing stop and I have only half the changes in the schema. Then I have to manually repair and change my SQL file, take out the already integrated changes and build up the file later for the production system.

If this is not possible I vote for transactions for DDL statements :-)

How to repeat:
...

Suggested fix:
...

Thank you for a feature request. I think, you can write some program of this kind yourself, using our C API, for example. So, I see no need to add this feature to any of existing MySQL clients.