on 05/20/2004 10:18 PM, David Griffiths at [EMAIL PROTECTED] wrote: >> >> I can use any I like, I wont have not even built the DB yet, so I am open to >> any suggestions. >> >> I don't see how I can do it all in one transaction, what does that mean? >> >> >> > What that means is you do 100,000 inserts, and then do one commit at the > end. If the connection to the database dies, or the database itself > crashes, then all the rows inserted will be rolled back, and no data > will be in your database.
Do you have to do something before the first insert to tell it there is a marker point to rollback to? Perhaps someone can show me a example ala php on this one? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
