thanks. i'll start it with the value i need. it increments after that ;)
Heikki Tuuri wrote: > 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 > > > -- 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