Re: changing an auto_increment value in innodb

2004-05-30 Thread Daniel Kasak
Gerben Gieling wrote: Dear all, I have an auto_increment value in an innodb table. I recently introduced a new row by mistake and removed it. I beleive I read somewhere in the manual that an innodb table does not reuse this number by default. I also remember vaguely that it is possible to reset thi

changing an auto_increment value in innodb

2004-05-28 Thread Gerben Gieling
Dear all, I have an auto_increment value in an innodb table. I recently introduced a new row by mistake and removed it. I beleive I read somewhere in the manual that an innodb table does not reuse this number by default. I also remember vaguely that it is possible to reset this next autoincrement