An exception occurred when using Navicat for MySQL & quot; You have an error in your

An exception occurred when using Navicat for MySQL. "You have an error in your SQL syntax ...... "solved [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 'syntax # first, make sure that the SQL statement has no syntax error. It is generally caused by the encoding of the SQL file. You can try to switch the encoding and run it again. For example, if one of my SQL files is utf8, But I modified some content of the file and run it with utf8 encoding, the above error will appear. After that, I switched to ansi and ran it using 936 (ANSI/OEM-Simplified Chinese GBK) encoding. Then I switched the file to utf8 encoding and tried again, or else. The solution to this problem is to start with encoding.