resetting id numbers, is that a common practice?

[toptomato]

Is it a common practice to want to periodically renumber a tables id column (int primary key, auto_increment)?

meaning that, over time, as some rows get deleted, it would desirable to reset the id's so numbers are not skipped?

and if so, is there a mysql or PHP function that would do that?,


thanks for the help

[svidgen]

Not common as far as I've seen. And doing so would normally be a pretty tedious and error-prone process with little to no return on the investment.

If you're running out of PK's, the "solution" is to convert to BIGINT, GUID, or multipart PK's.