Re: How does a multi-row INSERT work?

[beacker]

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)