Check MySQL syntax

Hello.
Is there any way to check query syntax on Query tab before executing?
Or can I execute query to check if it's right but without actually applying changes to database?

You could fire a "EXPLAIN <your query>" Query to check it. If it has a Syntax error, MySQL will tell you so. If not, MySQL just returns some analysis rows.

Hi, ansgar. Thanks for the answer, but I have many statements, run EXPLAIN for each is very long way.
Moreover, "Before MySQL 5.6.3, SELECT is the only explainable statement." so it can't explain other statements types on earlier versions of MySQL.
I wish to check all in .sql file and run it after succesful check.

So what's about it?

You can perhaps wrap your whole SQL code in a transaction and cancel that in the end, like this:

BEGIN TRANSACTION;
INSERT INTO...;
DELETE FROM...;
ROLLBACK TRANSACTION;

It's option, but don't you plan create native function for this need?

No, definitely not. The MySQL server is the only instance which can check the SQL syntax reliably.