How does it compare to bulk insert? It's faster.
Making 1000 round trips to the database is slower than
1.
Try it out on your database. If it doesn't work, then
you must do a for loop.
--- Michael Campbell <[EMAIL PROTECTED]>
wrote:
> On 11/3/05, Paul Benedict <[EMAIL PROTECTED]>
> wrote:
> > Yes,
> >
> > SQL has a notation to INSERT multiple entries at
> once.
> > What you want to do is build a statement like the
> > following:
> >
> > INSERT INTO fruit (id, name) VALUES (0, 'Pear'),
> (1,
> > 'Apple'), (2, 'Peach')
>
>
> Is that standard ANSI SQL? I know MySql supports
> that syntax, but
> wasn't aware that many (any?) others did.
>
> --
> I tend to view "truly flexible" by another term:
> "Make everything
> equally hard". -- DHH
>
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
