[thelist] INT VS BIGINT
Russell Griechen
russgri at bellsouth.net
Sun Feb 23 14:56:01 CST 2003
rudy...the resident SQL poet laureaute wrote:
>don't use BIGINT unless you plan to have more than 2,147,483,647 categories
>don't use INTEGER unless you plan to have more than 32,767
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
b. simply change the INT TO BIGINT
????
c. Can you just flush the data and droptables?
Russell Griechen
More information about the thelist
mailing list