Hi, is there a way to start a primary key from 10001 and using auto_increment. Ive got it to work with zerofill but that just gives me 00001, 00002 etc, but what i want to do is start from 10001, 10002 etc. is this possible or not? thanks in advance
You could try
removing the auto increment add record with 10000 in id field turn on autoincrement again
Next rec added should now be 10001
You can now delete the 10000 dummy record.
Ok cheers, ill give it a go, just wasnt sure if mysql had a built in function to do it.
