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
), 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