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 ;-)