Can we have the table name as "option" in MySQL?

Question

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

Answer 1

If you want to have a table name Option, you should be able to, just remember that whenever you use the table in a query, you will have to encase it in ` symbols. Like this.

`option`

The ` key on the top left of your keyboard, with the tilde.

Answer 2

You can use SQL keywords as table names in MySQL if you escape them with back-quotes.

 CREATE TABLE `option` (
     ...
 )

It's not normally a good idea to do so, though.

Answer 3

option is a reserved word in MySQL. Save yourself a world of pain and use choice for your table name.

Answer 4

See the MySQL documentation on this. You can do it as follows:

create table `option` (
...
)

Answer 5

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.

Answer 6

option is a reserved word in Mysql.we can use a reserved word by using the word inside a single quotes.

Answer 7

Better you select the other tablename.Ohterwise maintaining our code will be difficult.