[EMAIL PROTECTED] wrote:
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/26/2005 11:02:30 AM:
Hi,
is there anyway that I can have more than 20 digits for integer
(bigInt)? If not, what I can use for database index?
BIGINT UNSIGNED can range from 0 to 18446744073709551615
(http://dev.mysql.co
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/27/2005 12:28:27 PM:
> >Are you actually saying that you have a database with more than 1.8e+19
> >records in it? I don't think you do. I think you are combining several
> >pieces of information into something that looks like a number and it's
> >e
[EMAIL PROTECTED] wrote on 27/06/2005 16:33:44:
> Are you actually saying that you have a database with more than 1.8e+19
> records in it? I don't think you do.
If you were to add records at the rate of a million a second, which is, I
think, beyond the capabilities of any foreseeable future h
ning digit.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, June 27, 2005 10:34 AM
To: Eko Budiharto
Cc: mysql@lists.mysql.com
Subject: Re: question about field length for integer
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/26/2005 11:02:30
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/26/2005 11:02:30 AM:
> Hi,
> is there anyway that I can have more than 20 digits for integer
> (bigInt)? If not, what I can use for database index?
BIGINT UNSIGNED can range from 0 to 18446744073709551615
(http://dev.mysql.com/doc/mysql/en/numeric-ty
