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?
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?