MySQL ?

[fnbcprog]

How do you get a primary key, auto_increment field to start counting at 1000000 instead of 1?

[Wien]

ALTER TABLE tbl_name AUTO_INCREMENT = 100
will start your records at 100