sql create table query

[Sravani saka]

can we use double quotes to the column name while creating a table?? if yes, then how to insert the records into it???

[akmozo]

Hi,

No, you can not use double quotes while creating a table.

Create a table :

create table your_table (
  id int(11) NOT NULL,
  name varchar(50) NOT NULL,
  PRIMARY KEY(id)
);

Insert data into the table :

insert into your_table(id, name) values(1, 'Bill');
insert into your_table(id, name) values(2, "Bill");

[Sravani saka]

hey thanq for ur help.. but i tried with double quotes, and it worked.. it is like this
create table cust_info(id number, "name" varchar2(50))//i think double quotes is optional

insert into cust_info(1,'Bill')

[pritaeas]

http://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm

See paragraph 2.2.2

[akmozo]

Sorry, I thought that you are speaking about mysql.

Sorry again.

[pritaeas]

Sorry, I thought that you are speaking about mysql.

Me too at first, but it is also valid for MySQL...