Starting Value for AUTO_INCREMENT
Posted: Tue Jan 07, 2003 2:32 am
How do I specify a starting value for use with AUTO_INCREMENT?
example create table script:
CREATE TABLE egtable (
egcolname INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
etc,etc,etc);
In place of starting the numbering at 1, I may like to start the numbering at 10000.
Any advice will be appreciated. Thank you.
-Dickey
example create table script:
CREATE TABLE egtable (
egcolname INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
etc,etc,etc);
In place of starting the numbering at 1, I may like to start the numbering at 10000.
Any advice will be appreciated. Thank you.
-Dickey