Next Autoindex question...

[Sharif]

How can I change what the next autoindex of a table should be through PHPMYADMIN? My tables next autoindex is supposed to be 13 but instead its 500003. I don't know why.. help!

[YappyDog]

ALTER TABLE tbl_name AUTO_INCREMENT = 100

will start your records at 100

[Sharif]

THANK YOU SO MUCH!

[Volitics]

Sharid said:
My tables next autoindex is supposed to be 13 but instead its 500003. I don't know why

I've got the same problem that Sharif had. My table only has 7 records. They should be numbered '1', '2', '3', '4', '5', '6', '7'.

Instead they are numbered '51223019','51223020','51223021','51223022','51223023','51223024','51223025'.

The PhpMyAdmin down at the bottom says "Next Autoindex 51,223,027"

In the past I've had tables do the exact same thing. I emptied the table and started with new data. That fixed the problem.

But with this table the web site is starting to go live. It would be impractical to dump a table with users maybe looking at the data.

Can anybody tell me the reason why MySQL jumped from single digits up to the millions like that?

Thanks.

[Sharif]

I dont know why you had this problem, I had it because I messed up and made a row where the id was purposely huge number when it shouldve been like 8 or 9.