[thelist] auto-increment with mysql

rudy rudy937 at rogers.com
Fri Jul 18 18:24:21 CDT 2003

> 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

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


More information about the thelist mailing list