[thelist] SQL Question: "Fill in" missing auto-increment records
Luther, Ron
Ron.Luther at hp.com
Wed May 29 17:11:01 CDT 2002
Hi David,
Changing user id numbers seems like a bad idea to me ....
You realize you lose all your tracking and history and multi-table interactions, right?
... but try dropping the field and re-adding it. I think that should renumber it.
RonL.
(Still wondering how that "improves accuracy" ???)
-----Original Message-----
From: David Bindel [mailto:dbindel at austin.rr.com]
I am creating a user registration MyISAM database in MySQL that has an
auto-incremented ID field.
Periodically (about once a month), I will run a script that removes user
records that have not been used in the previous month (to keep size down and
accuracy up.)
More information about the thelist
mailing list