Mysql intelligent error interpreter

Question

I am looking for an application that will give me more descriptive information about syntax errors in SQL queries than:

You have an error in the SQL syntax; check the manual that matches the version of your MySQL server for the correct syntax to use next (...)

Finally, I always find out what is wrong with my request, but it is a little strange that the error messages are so general. I knew that it was difficult to pinpoint errors in a language such as SQL, but using at least some heuristics (if not exact rules), it should be possible to give some suggestions about common possible problems.

Does anyone know such a tool?

Answer 1

MySQL bison/flex.

( MySQL) , , , .

, :

(... (.....)

? , , , . , . , , C ( ), , .

:

, s = '' r = '' ';

? "" where, :

, s = "' r =' '";

, :

, s = '' r = '';

, , , SQL. , , . , , , -, -.

, , MySQL , , .

Answer 2

, , , mysql . , - .