List:General Discussion« Previous MessageNext Message »
From:beacker Date:March 31 2005 9:31pm
Subject:Re: How does a multi-row INSERT work?
View as plain text  
Chris W. Parker writes:
>I searched the archives, looked through the manual, and searched google
>for info on how to actually perform a multi-row INSERT but didn't find
>an answer.

The basic syntax is to separate the (...) with commas (,) ala:

create table table1 (sku int, title varchar (20));
insert into table1 (sku, title) values (1,'A'), (2, 'B');

Brad Eacker (beacker@stripped)
Thread
How does a multi-row INSERT work?Chris W. Parker31 Mar
  • Re: How does a multi-row INSERT work?Jonathan Wright31 Mar
  • Re: How does a multi-row INSERT work?Dan Nelson31 Mar
    • Re: How does a multi-row INSERT work?SGreen31 Mar
  • Re: How does a multi-row INSERT work?John McCaskey31 Mar
  • Re: How does a multi-row INSERT work?Rhino1 Apr
  • Re: How does a multi-row INSERT work?Gabriel PREDA1 Apr
RE: How does a multi-row INSERT work?Chris W. Parker31 Mar
Re: How does a multi-row INSERT work?beacker31 Mar