In article <[EMAIL PROTECTED]>,
Dennis Bjorklund <[EMAIL PROTECTED]> 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 ;-)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
