Re: Multi-row INSERTs

2004-06-10 Thread Russ Brown
-- From: Russ Brown [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 7:45 AM To: [EMAIL PROTECTED] Subject: Re: Multi-row INSERTs 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 &g

RE: Multi-row INSERTs

2004-06-09 Thread Donny Simonton
n, it gets slower. Donny > -Original Message- > From: Russ Brown [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 09, 2004 7:45 AM > To: [EMAIL PROTECTED] > Subject: Re: Multi-row INSERTs > > On Wed, 9 Jun 2004 12:58:01 +0200, Jigal van Hemert <[EMAIL PROTECTED]> &

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,

Re: Multi-row INSERTs

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

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