[Err] 1064, err1064
[Err] 1064-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 at line 3
This error is prompted when the SQL statement is executed in MySQL 5.6, Navicat For MySQL 10.0.10. the following error is prompted when the statement in the SQL file is executed in CMD:
D: \ Users \ Aven> mysql-uroot-p <F: \ Publish \ Data \ pai_update.sqlwarning: Using a password on the command line interface can be insecure. ERROR 1064 (42000) at line 4: 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 'alter listen TABLE listen mcu listen CHANGE Listen 'local _ id' listen to VARCHAR (50) listen to 'at line 1
Solution:
The key to solving this problem is that the spaces in the error prompt are "listening", which reminds me of the file encoding problem and then converts the file encoding.
We recommend that you use Notepad ++ for Easy Encoding and conversion,
Convert to UTF-8 format, the problem persists, then convert to ANSI format try:
Haha, it's easy to see it! Put? Replace them with spaces, save them, and execute them again. Everything is OK.
Reflection:
Why is this problem?
These statements are copied from QQ to Word, and from Word to Notepad ++,
It is estimated that there is a problem with the space copied from QQ or Word.