Re: Multi-row INSERTs

2004-06-10 Thread Russ Brown
think it's a case of using the right tool for the job at hand really. Still, if 1) is guaranteed to work I could knock off yet another query. ;-) I'm surprised that nobody knows the answer on that for sure... -Original Message- From: Russ Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday

Multi-row INSERTs

2004-06-09 Thread 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

Re: Multi-row INSERTs

2004-06-09 Thread Russ Brown
On Wed, 9 Jun 2004 12:58:01 +0200, Jigal van Hemert [EMAIL PROTECTED] wrote: 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,