Re: COPY vs INSERT

In article <Pine.LNX.4.44.0505060927520.7072-100000@zigo.dhs.org>,
Dennis Bjorklund <db@zigo.dhs.org> writes:

> On Fri, 6 May 2005, Jim C. Nasby wrote:
>> Has thought been given to supporting inserting multiple rows in a single
>> insert? DB2 supported:
>>
>> INSERT INTO table VALUES(
>> (1,2,3),
>> (4,5,6),
>> (7,8,9)
>> );
>>
>> I'm not sure how standard that is or if other databases support it.

> The sql standard include this, except that you can not have the outer ().
> So it should be

> INSERT INTO table VALUES
>     (1,2,3),
>     (4,5,6),
>     (7,8,9);

Since MySQL has benn supporting this idiom for ages, it can't be
standard ;-)