autoincrement starting number

wxdqz

New Member
I realize that I can create a new autoincrement field in an existing table (already populated) and have it filled upon creation (of the new field) using the syntax:

ALTER TABLE table_name ADD column ID smallint(6) NOT NULL auto_increment primary key;

BUT, how can I do this so that the count begins with something other than 1? How about 10000?
 
Back
Top