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

Recommended Answers

Sorry, I thought that you are speaking about mysql.

Sorry again.

Jump to Post

All 5 Replies

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");

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')

Sorry, I thought that you are speaking about mysql.

Sorry again.

Sorry, I thought that you are speaking about mysql.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.