Hello,
I tried searching the archives for this, but since the search tool is returning no results when searching for 'INSERT' I figured it's not working. :-)
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.
Now, I can't find the answer to this in the documentation, and nobody I've asked knows for a fact what the answer is. I personally suspect that it is, since I don't think any other operation will be able to insert in the middle of the multi-row insert, since that will be executed as one statement (which is what it is).
However, I can't use this unless I know for an absolute fact that this is indeed the case.
Conversely, if I know for a fact that it is not guaranteed, I know that I need to think of something else. :-)
Thanks,
--
Russ
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
