Changing First Autoincrement Value [SOLVED]

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
tecktalkcm0391
DevNet Resident
Posts: 1030
Joined: Fri May 26, 2006 9:25 am
Location: Florida

Changing First Autoincrement Value [SOLVED]

Post by tecktalkcm0391 »

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....
Last edited by tecktalkcm0391 on Mon Jun 12, 2006 1:26 pm, edited 1 time in total.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

do a table export, and you'll notice something along the lines of AUTO_INCREMENT = 14;
User avatar
tecktalkcm0391
DevNet Resident
Posts: 1030
Joined: Fri May 26, 2006 9:25 am
Location: Florida

Post by tecktalkcm0391 »

OK, found it! THANKS!
Post Reply