re:issue with create table

[smitashirole]

can we create table with tablename as TABLE
eg. create table TABLE(no int ,name varchar(20));
like this.

[ronverdonk]

Welcome to The Scripts!

NO you cannot, 'table' is a reserved word in MySQL.

Ronald :cool:

[zottty]

I'm not sure about this, and can't try it right now, but give this a try:
create table `TABLE`(no int ,name varchar(20));

[ronverdonk]

Yes you can use that name within 'back-ticks'.
But you must then be prepared to ALWAYS use these back-ticks when you use that table name.

Ronald :cool: