RE: Innodb auto increment - reset itself automatically?

2005-02-11 Thread Tom Crimmins
bruary 11, 2005 22:16 > To: mysql@lists.mysql.com > Subject: Innodb auto increment - reset itself automatically? > > Hi, > > My database is mostly made up of MyIsam tables, and some > InnoDB tables. > > One particular Innodb table works fine with an auto increment field. &

Re: Innodb auto increment - reset itself automatically?

2005-02-11 Thread Greg Whalin
http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html Rishi Daryanani wrote: Hi, My database is mostly made up of MyIsam tables, and some InnoDB tables. One particular Innodb table works fine with an auto increment field. The table is updated often, records being added and deleted at

Innodb auto increment - reset itself automatically?

2005-02-11 Thread Rishi Daryanani
Hi, My database is mostly made up of MyIsam tables, and some InnoDB tables. One particular Innodb table works fine with an auto increment field. The table is updated often, records being added and deleted at pretty much the same rate. So, there are only a very few records in the table at any giv