When 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.