[thelist] INT VS BIGINT
rudy
r937 at interlog.com
Sun Feb 23 15:38:01 CST 2003
> If I start with INTEGER and later on get close to the 2,147* entries what
> are my options.
> a. drop table *** ....convert to BIGINT
if you have over 2 billion rows, then dropping the table may take a while
reloading it certainly will
> b. simply change the INT TO BIGINT
some databases may let you do that in an ALTER, yes
try it with a few rows now, before it gets near 2 billion...
rudy
More information about the thelist
mailing list