关于``的Sql语法错误

Question

I have never seen this problem. I want to make a MySQL query (insert, update, select) but MySQL gives an error.

My query:

SELECT * FROM option

and error:

[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 'option' at line 1]

but if i put ``

SELECT * FROM `option`

it's working. What can i do?

Answer 1

option is reserved word for MySQL you need to enclose it with backticks or avoid it by changing table name

SELECT * FROM `option`