Joe, sorry, I did not know AUTO_INCREMENT=... clause does not work with InnoDB. I will look if it is easy to fix.
A workaround is that you insert the first row which the auto-inc column value explicitly specified: INSERT INTO some_table VALUES (1500, 'joe'); Then InnoDB starts to increment from 1500 up. Regards, Heikki http://www.innodb.com/ibman.html >FYI: im using mysql 3.23.44 >auto_increment doesn't seem to work with InnoDB. i've tried to create a >table with:create table some_table ( > uid INT UNSIGNED AUTO_INCREMENT NOT NULL DEFAULT 1500, > user VARCHAR(100) NOT NULL, PRIMARY KEY (uid), UNIQUE KEY (uid) >) TYPE=INNODB; >i've also tried: >create table some_table ( > uid INT UNSIGNED AUTO_INCREMENT NOT NULL, user VARCHAR(100) NOT NULL, > PRIMARY KEY (uid), UNIQUE KEY (uid)) TYPE=INNODB AUTO_INCREMENT = 1500; >when i insert records and run a select statement i get: >+-----+------+ >| uid | user | >+-----+------+ >| 1 | joe | >| 2 | bob | >+-----+------+ >when i create a table using TYPE = MYISAM, it works: > >create table some_table ( > uid INT UNSIGNED AUTO_INCREMENT NOT NULL, user VARCHAR(100) NOT NULL, > PRIMARY KEY (uid), UNIQUE KEY (uid)) TYPE=MYISAM AUTO_INCREMENT=1500; >or when i do:create table some_table ( > uid INT UNSIGNED AUTO_INCREMENT NOT NULL DEFAULT 1500, > user VARCHAR(100) NOT NULL, PRIMARY KEY (uid), UNIQUE KEY (uid) >) TYPE=MYISAM;now when i insert and select i get:+------+------+| uid | user | >+------+------+| 1500 | joe || 1501 | bob |+------+------+ >the insert statement i did was:insert into some_table (user) values ('joe'); >insert into some_table (user) values ('bob'); >can anyone tell me if auto_incrememt works with InnoDB? > >-- Joe Ellis >http://www.lithodyne.net >79:6f:75 68:61:76:65 74:6f:6f 6d:75:63:68 >74:69:6d:65 6f:6e 79:6f:75:72 68:61:6e:64:73 --------------------------------------------------------------------- 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