Re: Repeat loops in mysql, large data issue, suggestions wanted

[Scott Haneda]

on 05/20/2004 10:18 PM, David Griffiths at dgriffiths@stripped 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: [phone]
http://www.newgeo.com                       Fax: [phone]
scott@stripped                            Novato, CA U.S.A.