mysql table option,我们可以将表名称为“option”在MySQL？

I am very, very new to MYSQL.I tried to create a table named "option".

My SQL Query is :

create table option(

id int not null primary key auto_increment,

choice varchar(30)

)

While executing this query it shows the following error

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 'option(

id int not null primary key auto_increment,

choice varchar(30)

)' at line 1

(0 ms taken)

If I try with the table name as "choice" it is working.

can we have the table name as "option" in mysql?

thanks

解决方案

Pick a different name (one that isn't a reserved word in your RDBMS) and save yourself and whoever else might work on it many headaches.