Am Montag, den 01.12.2008, 19:15 +0100 schrieb Joachim Zobel: > Is there any chance there is a 0 PK? This may trigger an auto > increment.
To bee more specific: mysql> CREATE TABLE test (t INTEGER PRIMARY KEY AUTO_INCREMENT); Query OK, 0 rows affected (0.11 sec) mysql> INSERT INTO test(t) VALUES(0); Query OK, 1 row affected (0.06 sec) mysql> INSERT INTO test(t) VALUES(1); ERROR 1062 (23000): Duplicate entry '1' for key 1 See http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_no_auto_value_on_zero for an explanation. Sincerely, Joachim _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
