OK, db2 supports it, but I¹ll withdraw the question if it isn¹t SQL standard
On 12/19/07 1:02 PM, "Galen Rhodes" <[EMAIL PROTECTED]> wrote: > It's been around a while but I don't think it's a standard. MySQL supports > and, I think, Oracle supports it. > > > -- > Galen Rhodes > [EMAIL PROTECTED] > > > On Dec 19, 2007, at 12:57 PM, Mark Morris wrote: > >> I've never seen this insert syntax. Is this new, or have I just missed it? >> >> Thanks, >> Mark >> >> On Dec 19, 2007, at 11:45 AM, Charles Koppelman wrote: >> >>> So ERX provides us with a great way to do massive updates >>> (ERXEOAccessUtilities.updateRowsDescribedByQualifier). Is there a way that >>> anyone on this list has come up with to do massive INSERTs? >>> >>> Looking at the code, it seems that inserts are done exclusively through >>> insertRow methods, meaning one insert statement per row. However, SQL >>> supports multiple inserts into the same table like: >>> >>> INSERT INTO MY_TABLE >>> (ID, COLUMN_A, COLUMN_B) >>> VALUES (1, 'A', 'B'), >>> (2, 'C', 'D'), >>> (3, 'E', 'F'); >>> >>> Has anyone implemented this? >>> >>> Charles Koppelman >>> >>> Programmer >>> Youth For Understanding, USA >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/markm%40onpointsoftwar >>> e.com >>> >>> This email sent to [EMAIL PROTECTED] >>> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/grhodes%40thissmallworl >> d.com >> >> This email sent to [EMAIL PROTECTED] > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/koppelman%40yfu.org > > This email sent to [EMAIL PROTECTED]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]