David - there's some info in the online docs here:
To start with an AUTO_INCREMENT value other than 1, you can set that
value with CREATE TABLE or ALTER TABLE, like this:
mysql> ALTER TABLE tbl AUTO_INCREMENT = 100;
On 9/22/06, dpgirago@stripped <dpgirago@stripped> wrote:
> I seem to recall that when creating a table, you could designate an
> auto_increment field to begin counting at zero(0) instead of one (1), but I
> can't find an example in the documents.
> I'm using 4.0.16 and table type=myisam.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1