[ERR] 1064-you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-to-line 3
This error is prompted when the SQL statement is executed in MySQL 5.6,navicat for MySQL 10.0.10, and the following error is prompted when executing the statement in the SQL file in cmd:
D:\users\aven>mysql-uroot-p < f:\publish\data\share_update.sqlwarning:usingaPasswordOn the command line interface can insecure .ERROR1064(42000) at Line 4: You have anErrorinchyour SQL syntax; Check theManual that corresponds toYour MySQL serverversion for the RightSyntax toUse near' Alter listen to the MCU listen to the change listen to ' local_id ' listen ' local_id ' listen to varchar (50) Listen ' at Line 1
Solution:
The key to solving the problem is that the blanks in the error prompt are "Listen", which reminds me of the encoding problem of the file and then the conversion of the file encoding.
It is recommended to use notepad++, the code conversion is very convenient,
Convert to UTF-8 format, the problem is still, and then to ANSI format try:
Haha, the true colours of the bar! Put are replaced with spaces, saved, then executed, everything OK.
Reflection:
Why does this problem occur?
These statements are copied from QQ to Word, and the double is copied from Word to notepad++.
It is estimated that there is a problem with the space copied from QQ or word.
[ERR] 1064-you has an error in your SQL syntax; Check the manual that corresponds to your MySQL s