I've had the same issue. The problem, as I saw it, was that I inserted a
negatvie value into the ID field. For some reason, it "rolls" to the
highest possible positive numeric value if a negative number is used in the
ID field.
I made the field unsigned to address this issue in mySQL, but, t
William R. Mussatto writes:
> On Wed, 14 Feb 2001, Sinisa Milivojevic wrote:
>
> can an auto_increment column also have the attribute "unsigned" safely?
>
> Sincerely,
>
> William Mussatto, Senior Systems Engineer
> CyberStrategies, Inc
> ph. 909-920-9154 ext. 27
>
>
Yes it can.
On Wed, 14 Feb 2001, Sinisa Milivojevic wrote:
> Date: Wed, 14 Feb 2001 16:21:31 +0200 (EET)
> From: Sinisa Milivojevic <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: auto_increment problem with mysql 3.23.32
snip..
>
> Hi!
On Wed, Feb 14, 2001 at 04:21:31PM +0200, Sinisa Milivojevic wrote:
> Hi!
>
> The above is actually documented behaviour.
I've just realized that it's true (checked). But it was supported by older
mysql versions and now I'm getting stuck with the old tables (MyISAM).
>
> Entering negative valu
Gábor Lénárt writes:
> On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote:
> > Hi!
> >
> > I have just tested your case on my Linux and it worked just fine.
> >
> > What OS is that and are you using our binaries. If not, please do.
>
> OK, I will (but it takes some time
On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote:
> Hi!
>
> I have just tested your case on my Linux and it worked just fine.
>
> What OS is that and are you using our binaries. If not, please do.
OK, I will (but it takes some time to download).
Till that I have got a more acc
Gábor Lénárt writes:
> Hi,
>
> It's me again ;-) Now I have got a very serious problem. I've just downloaded
> 3.23.32 and compile then run it without any major trouble. BUT my headache
> is about this:
>
>
> mysql> insert into cikk values (NULL,'Beta','','','','','N','','',NULL,0,0,0,0
