dineshsivam

 Profile Answers by dineshsivam Questions by dineshsivam

• May 31st, 2010

 

Use like this...

INSERT INTO TABLENAME (column1,column2...) VALUES (value1,value2,,,,), (value1,value2,,,,)(value1,value2,,,,),....

psingla

 Profile Answers by psingla Questions by psingla

• Nov 8th, 2010

 

1)
insert into table (col1,col2) values (val1,val2),(val3,val4)
2)
insert into table (col1,col2)
select val1,val2
union all
select val3,val4

psingla

 Profile Answers by psingla Questions by psingla

• Nov 8th, 2010

 

Commas are getting deleted here, so put commas between columns and values.