resetting id numbers, is that a common practice?
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
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)