Re: Multiple Row Insert in SQL?

I thought the format was something like

INSERT INTO mytable (field1, field2, field3) values ('blah1','blah2','blah3'),
('blah2a','blah2b','blah2c'), ('blahagain','andagain','andagain');

HTH,
Loyd

On Mon, 03 Nov 2003 18:00:16 -0500, "Michael Naughton"
<mnaughton@xxxxxxxxxxxx> wrote:

>Is there any way to insert multiple rows into a table without  using a
>select clause? I'd like to build a SQL statement in a program that just
>contains discrete values (no references to anything outside of the
>statement except the table being inserted into). It works fine with just
>one row, but I can't get VALUES to work with more than one.
>
>Am I just out of luck?  Thanks!
>
>Mike Naughton
>Senior Programmer/Analyst
>Judd Wire, Inc.
>124 Turnpike Road
>Turners Falls, MA  01376
>413-863-4357 x444
>mnaughton@xxxxxxxxxxxx