I am aware of that. But from my experience MySQL returns the the rows in the order that you inserted them. Assuming this is the case, I was wondering if the result I have seen means that the order of autoincrement values does not correspond to the order in which inserts are done.
Frank On Mon, 27 Dec 2004 14:44, sol beach wrote: > Unless & until you use an ORDER BY clause > the order of the rows returned by SELECT is indeterminate (unpredictable). > > > On Mon, 27 Dec 2004 13:45:37 +1300, Frank Sonntag > > <[EMAIL PROTECTED]> wrote: > > Hi, > > > > does InnoDB guarantee that the values of an autoincrement column do > > always increase? > > What happened to me is that a select * from my_table returns something > > like > > > > id | ... > > > > 10 > > 11 > > 5 > > 12 > > 13 > > > > where id is defined as int(10) unsigned NOT NULL auto_increment > > and is the primary key of the table. > > The inserts corresponding to ids (10, 11, 12, 13) are done inside one > > transaction, the insert that generates id = 5, in another (concurrent) > > one. > > > > Cheers > > Frank > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
