[thelist] auto-increment with mysql

Aredridel aredridel at nbtsc.org
Fri Jul 18 19:10:25 CDT 2003


On Fri, 2003-07-18 at 17:24, rudy wrote:
> > 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

use alter table to do it live, even.



More information about the thelist mailing list