Simple Mysql question...

[r_sole]

How can I stop the auto increment just keep going up? How can I make it so it counts the amount of rows instead?

For example, if I had 3 rows (auto increments up to 3) and then decided to delete number 3, I want the auto increment to be 3 next time (because now theres only 2 rows left and 3 should be the next in the sequence) but instead 4 will be the next increment.

[Chris J]

Just run the following sql query:

ALTER TABLE tablename AUTO_INCREMENT = 3

[r_sole]

hmm alright. Thanks

[Michaelttkk]

another possible solution I have been using is, you delete the autoincremented no/number and recreated it.

example, no firstname lastname (the table structure)
delete the no

then, recreated the no again(autoincremented etc.) before the firstname