I was wondering how to set a database table to where when i add a product to the table, the primary key named "id" with start at 0001 and auto increment up to 9999 at the max. So really I would like to know is how to get the "id" to start incrementing at 0001 if at all possible?
And you configure your column to be smallint with 4 numbers. You'll have to take care of not going to 10000 because the records simply won't be saved in the DB.
I don't know how to reset the auto-increment to 0001 again though.