Re: Multi-row INSERTs

[Jigal van Hemert]

> 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.