1064: You have an error in your SQL syntax
MySQLWhat does it mean?
The SQL statement has a syntax error; the server could not parse it. The message shows the text near the error.
Why does it happen?
A typo, a missing/extra comma or parenthesis, a reserved word used unquoted as a column/table name, syntax not supported by the MySQL version, or quoting/escaping errors.
How to fix it
The 'near ...' part of the message shows where the error starts; look immediately before it. Quote reserved words with backticks: order, group. Balance parentheses and commas. Verify that you are using syntax supported by your version. If you generate dynamic SQL, log and inspect the full resulting query.
More from this engine
- 1213Deadlock found when trying to get lock; try restarting transaction
- 1205Lock wait timeout exceeded; try restarting transaction
- 1040Too many connections
- 1146Table doesn't exist
- 1054Unknown column in field list
- 2002Can't connect to local MySQL server through socket
- 2003Can't connect to MySQL server (TCP/IP)