Saturday, June 23, 2012

insert multiple values using single statement in sql


INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data3', 'data4'),
  ('data5', 'data6'),
  ('data7', 'data8');

0 comments:

Post a Comment