Re: Help with Auto Increment

2001-12-05 Thread Erik Price
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

RE: Help with Auto Increment

2001-12-05 Thread Rick Emery
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