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 this next autoincrement value (I want the next insert to reuse this number). I cannot find it in the manual now I need it.
I'm only on the digest list so please (b)cc to me directly.
Gerben Gieling
Patent Information Specialist
I had to do this the other day. I *think* I used the command:
alter table table_name auto_increment=new_auto_increment_value;
Although I can't remember the exact method I used ( I found a few options ), I remember that I had to change the table to MyISAM before it would accept the change, and then change it back to InnoDB later ... so this obviously isn't ideal if you have foreign keys set up.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
