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 = 1000;
"Brian Bendtsen" <br*@mentor-it.dk> wrote in message
news:44***********************@dread15.news.tele.d k...
Hi
Is there at way to reset a table and set the auto increment value to 1000?
/Brian Bendtsen