Tell you every SQL statement error, XXXXX error, in the position of the XXXXX, line1, this is not nonsense, you might as well tell me 'syntax error' come on, programming IDE no matter what kind of programming language, can accurately tell you where a line, specific how many characters there is a problem, very accurate positioning,
SQL syntax errors can be smart to such as: xx field appears variable type error, xx field values beyond the scope of setting the point of such?????


I believe this is the SQL beginners will run into problems, have? What are the Settings or tool, can make this tip more intelligent?? Bosses give directions,

CodePudding user response:

MYSQL does nothing special in this regard, in fact, even the MYSQL own management tools are very general,

Under the current error, can pay attention to the wrong place, also is in the front of the tip error sentence generally have erred,

The

reference

mysql> Select 1 from XXXXX whera eas=123
-> ;
ERROR 1064 (42000) : You have an ERROR in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' eas at line 1=123 '
Mysql>

CodePudding user response:

DbForge Studio for MySQL this tool useful,
But mysql own can be very intuitive, direct look at yntax to use near 'at the back of the statement is ok, then go to find the line,