ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Campbell <michael.campb...@gmail.com>
Subject Re: Bulk inserts
Date Thu, 03 Nov 2005 14:58:58 GMT
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