Can we have the table name as “option” in 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

Answers


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.


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.


Need Your Help

ASP USER LOGIN SCRIPT

asp-classic vbscript

When i try to login with the below code it give me an error saying

Free PHP script that downloads web pages

php scripting proxy

I want to know if someone knows where I can find a PHP script that does all the functions of web proxy?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.