I want to use the autonumber data type but need it to start at 500.
Many thanks
For MYSQL:
Specify the column as auto increment and put in a dummy row with that column set at 499, once the real data is put in it will start at 500 and you can remove the dummy row.
Note that while this works for some databases, others need an explicit command to set the sequence number. (like postgresql) but almost all databases have this documented in their respective documentation.
