> Anyway, my question is this. If I do a single-statement multi-line insert, > are the auto-increment IDs of the rows inserted guaranteed to be > sequential? Bear in mind also that I'm using InnoDB tables here. > > Conversely, if I know for a fact that it is not guaranteed, I know that I > need to think of something else. :-) Will locking the table work for you? If you lock the table for writing no other process can slip a query in between your queries for certain...
Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]