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
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,
e been the benefit of the fewer
queries issued. I 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---