of unsigned big ints (as keys)and this is the only
problem we've ever had.
Eric Pickup
http://buildacommunity.com
- Original Message -
From: "Fred van Engen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 20, 2001 9:41 AM
Subject: Re: BigInt
On Tue, Feb 20, 2001 at 06:56:28PM +0800, chchen wrote:
> hi all
>
> i use mysql-3.23.32
>
> my project need to use unsigned Bigint as a primary key.
> but when i insert many rows in this table.
> sometimes it will error with Duplicate such like
>
> insert into Table
>values('92318521725269771
First, i am really sorry about that.
my fields is quite simple.
CREATE TABLE TEST (
A bigint(20) unsigned DEFAULT '0' NOT NULL,
C0 bigint(20) unsigned DEFAULT '0' NOT NULL,
C1 bigint(20) unsigned DEFAULT '0' NOT NULL,
C2 bigint(20) unsigned DEFAULT '0' NOT NULL,
C3 bigint(20) unsig
Firstly, why do you have quotes around the numbers? I thought you said it
was bigint, not a string?
Secondly, if you are going reply/repost to the list, could you please
simplify it a bit. Provide field names, etc. Your insert is very difficult
to figure out especially with unmatched brackets,
