If you have a table with an auto_increment column and one of the rows has the value set to 0, doing an ALTER TABLE will change that value to either 2147483647 or the next auto_increment value.
mysql> create table blah (id int not null primary key auto_increment,stuff char(128)); Query OK, 0 rows affected (0.00 sec) mysql> insert into blah set stuff='blah'; Query OK, 1 row affected (0.00 sec) mysql> select * from blah; +----+-------+ | id | stuff | +----+-------+ | 1 | blah | +----+-------+ 1 row in set (0.01 sec) mysql> update blah set id=0; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from blah; +----+-------+ | id | stuff | +----+-------+ | 0 | blah | +----+-------+ 1 row in set (0.00 sec) mysql> alter table blah add morestuff int not null; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> select * from blah; +----+-------+-----------+ | id | stuff | morestuff | +----+-------+-----------+ | 2 | blah | 0 | +----+-------+-----------+ 1 row in set (0.00 sec) -- tani hosokawa river styx internet --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
