[thelist] auto-increment with mysql

[rudy]

> What does someone do once the limit /is/ reached
> assuming they didn't use the proper length range in
> the first place?

copy the contents of the table into an archive table (one which does not use
an auto_increment), drop the original table, re-declare it with a larger
auto_increment

there are nuances which can bite you in the soft nether regions, such as
related tables which need to keep the original id values, but if this is not
the case, you can simply reload the archived rows into the new table


rudy