• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Batch inserts
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Batch inserts


  • Subject: Batch inserts
  • From: Charles Koppelman <email@hidden>
  • Date: Wed, 19 Dec 2007 12:45:51 -0500
  • Thread-topic: Batch inserts

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

  • Follow-Ups:
    • Re: Batch inserts
      • From: Mike Schrag <email@hidden>
    • Re: Batch inserts
      • From: Kieran Kelleher <email@hidden>
    • Re: Batch inserts
      • From: Mark Morris <email@hidden>
References: 
 >Re: Where is WO 5.3.4 distributed ? (From: Gavin Eadie <email@hidden>)

  • Prev by Date: Re: Where is WO 5.3.4 distributed ?
  • Next by Date: Unable to locate WOOpenURL on your computer
  • Previous by thread: Re: Where is WO 5.3.4 distributed ?
  • Next by thread: Re: Batch inserts
  • Index(es):
    • Date
    • Thread