[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