Is there a way in MySQL to change the first autoincrement value so instead of it starting at 1 it starts at 1000?
I just want it to look a little better than having 1, 2, 3 for item numbers, Rather have it 1000, 10001, 1002....
Changing First Autoincrement Value [SOLVED]
Moderator: General Moderators
- tecktalkcm0391
- DevNet Resident
- Posts: 1030
- Joined: Fri May 26, 2006 9:25 am
- Location: Florida
Changing First Autoincrement Value [SOLVED]
Last edited by tecktalkcm0391 on Mon Jun 12, 2006 1:26 pm, edited 1 time in total.
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
- tecktalkcm0391
- DevNet Resident
- Posts: 1030
- Joined: Fri May 26, 2006 9:25 am
- Location: Florida