Hi,
If it possible to limit the max value of an auto increment field to say, ,
and how to do it? I am using MySQL 4.0.18.
Regards,
-- Wong
on 06/23/2004 12:14 AM, Joe Wong at [EMAIL PROTECTED] wrote:
> If it possible to limit the max value of an auto increment field to say,
> , and how to do it? I am using MySQL 4.0.18.
I am not sure, as a 'hack' you could simply insert a blank record with the
value set to ,, once
Scott Haneda <[EMAIL PROTECTED]> wrote:
> on 06/23/2004 12:14 AM, Joe Wong at [EMAIL PROTECTED] wrote:
>
>> If it possible to limit the max value of an auto increment field to say,
>> , and how to do it? I am using MySQL 4.0.18.
No. The maximum value for the auto_increment column can be
EMAIL PROTECTED]>
Sent: Wednesday, June 23, 2004 4:10 PM
Subject: Re: question on auto increment field
> Scott Haneda <[EMAIL PROTECTED]> wrote:
> > on 06/23/2004 12:14 AM, Joe Wong at [EMAIL PROTECTED] wrote:
> >
> >> If it possible to limit the max value of an
fying the value of UID
At 3, it failed and said:
Duplicate entry '16777215' for key 1
But I have only 1 record in the table.
Regards,
- Wong
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 23, 2004
>; "Egor Egorov" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, June 23, 2004 7:53 PM
Subject: Re: question on auto increment field
> At 17:33 +0800 6/23/04, Joe Wong wrote:
> >Hi Egor,
> >
> > Thanks for your reply. In addition to this, how