Multi-row INSERTs

[Russ Brown]

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