Re: Multiple Row Insert in SQL?

[Loyd Goodbar <loyd@xxxxxxxxxxxxxx>]

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
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.

--  
Mediocrity: It takes a lot less time and most people won't notice
the difference until it's too late. <http://www.despair.com/>
loyd@xxxxxxxxxxxxxx  ICQ#504581  http://www.blackrobes.net/