On 2006-06-11 Ferenczi Viktor wrote: > Cannot set the next auto_increment value in CREATE TABLE and > ALTER TABLE statements. No error message is returned, mysql > server just silently skip the command. ... > This feature should work starting with mysql-server 4.1.2. According to http://dev.mysql.com/doc/refman/4.1/en/innodb-auto-increment-column.html
"Beginning with MySQL 4.1.12, InnoDB supports the AUTO_INCREMENT = n table option in ALTER TABLE statements, to set the initial counter value or alter the current counter value. The same is true as of MySQL 4.1.14 for CREATE TABLE." So no version in Debian 3.1 Sarge does support InnoDB and AUTO_INCREMENT completely. BTW, when using InnoDB I would recommend you to try 5.0.x from www.backports.org. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
