Bill,
Wednesday, October 09, 2002, 6:55:26 PM, you wrote:
BH> Nope - nothing close to 4GB or even 1GB... My greatest data file size
BH> is 80MB. The largest table is 1.7 million rows. I have databases with
BH> more and bigger files. I think my problem is that the table having the
BH> proble
On 9 Oct 2002, at 11:55, Bill Hess wrote:
> One would think that the value would not top out until 2^31
> since I have it defined as a normal INT. I guess I can make it a
> BIGINT, but I think I will run into a problem eventually
> regardless how big I make the field...
Since the limit you're h
"Keith C. Ivey" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 08, 2002 4:52 PM
> Subject: Re: AUTO_INCREMENT max value...
>
>
>
>>Not really getting errors but getting warnings when inserting
>
> records
>
>>
, October 08, 2002 4:52 PM
Subject: Re: AUTO_INCREMENT max value...
> Not really getting errors but getting warnings when inserting
records
> and having duplicate values since the primary key is the one that is
> auto incremented...
>
> Keith C. Ivey wrote:
> > On 8 Oct 2002, at 12:23
Bill Hess wrote:
> Hello all...
>
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be able
> to handle a value bigger than what I am see
Not really getting errors but getting warnings when inserting records
and having duplicate values since the primary key is the one that is
auto incremented...
Keith C. Ivey wrote:
> On 8 Oct 2002, at 12:23, Bill Hess wrote:
>
>
>>What is the maximum value of an AUTO_INCREMENT field? I am cur
Did you try unsigned int?
Bill Hess wrote:
> Hello all...
>
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be
> able to handle a v
On 8 Oct 2002, at 12:23, Bill Hess wrote:
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be able
> to handle a value bigger than wh
