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
