In 3.23 or later: Just specify an ID of 1000 when you insert your first
record. If every record thereafter is INSERTed with ID = NULL (or just
not specified), then AUTO_INCREMENT will automatically bump up each ID
field by one after the first one. If you are loading data from
mysqlimport or
quoted from: http://www.bitbybit.dk/mysqlfaq/faq.html#auto_increment
In latter versions of MySQL, you can specify AUTO_INCREMENT=n as a table
option. This will tell MySQL to use n for the initial value. Any new rows
added will increment the counter by 1, as usual. This value is lost if you
delet