Page 1 of 1

Changing First Autoincrement Value [SOLVED]

Posted: Mon Jun 12, 2006 10:29 am
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....

Posted: Mon Jun 12, 2006 10:31 am
by John Cartwright
do a table export, and you'll notice something along the lines of AUTO_INCREMENT = 14;

Posted: Mon Jun 12, 2006 10:45 am
by tecktalkcm0391
OK, found it! THANKS!