Re: Batch inserts
Re: Batch inserts
- Subject: Re: Batch inserts
- From: Mark Morris <email@hidden>
- Date: Wed, 19 Dec 2007 11:57:28 -0600
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 (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >Batch inserts (From: Charles Koppelman <email@hidden>) |