ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: Bulk inserts
Date Thu, 03 Nov 2005 15:45:22 GMT
DB2 supports this syntax.
 Jeff Butler

 On 11/3/05, Michael Campbell <michael.campbell@gmail.com> wrote:
>
> On 11/3/05, Paul Benedict <paul4christ79@yahoo.com> 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
>

Mime
View raw message