[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