How to insert multiple rows in a single insert query?

psingla

 Profile Answers by psingla Questions by psingla

• Nov 8th, 2010

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

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,val2union allselect val3,val4

Answer Question  Select Best Answer