Errors due to reserved words
suggest changeWhen trying to select from a table called order
like this
select * from order
the error rises:
Error Code: 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 ‘order’ at line 1
Reserved keywords in MySQL need to be escaped with backticks (`)
select * from `order`
to distinguish between a keyword and a table or column name.
See also: Syntax error due to using a reserved word as a table or column name in MySQL.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents