hmm...question on mysql db id number auto_increment..

[shane85]

hey guys

so ive made a db and made it so each row as a product_id number...which auto increases for each time something is added. However, ive done like 50 test entries so my numbers go from

 

1,2,3,56,57,58

 

etc

 

I went in and edited them all so they are all in order and I have about 23 entries. However when I add the next one it goes to 59...so something is still telling it theres that many entries. How do I make it so the next entry will be after the last product_id number?

[ialsoagree]

ALTER TABLE table_name AUTO_INCREMENT = x

 

Where x is the new auto_increment value (the 1st number that will be given to the next record).

[jcbones]

Instead of x, just use number 1.  Mysql will auto adjust to the next available increment.

[shane85]

where would I put this statement? I dont use it in any of my querys accept when the db is first created.

[ialsoagree]

Yes, this change should only be run once. Either create a unique PHP file to run it, or run it on the command line when connected to MySQL or through software that manages a MySQL database like phpMyAdmin or GUI software that allows you to run SQL on the database.

[shane85]

perfect, ty!