auto increment from certain number 1

[derwent]

Not sure whether to ask in asp or this forum, but hey here goes...

I need to create a DB in MySQL with an id field that autoincrements. However, the first record is to start at 09100, then next is 09101, 09102, 09103 etc etc.

Is there any way to make the field begin at 09100 instead of 0?

Thanks folks

 

[towerbase]

The MySQL manual shows you how to do this:

http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html

Andrew
Hampshire, UK

 

[derwent]

superb, thanks