BigInt with primary key

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('9231852172526977164',0,0,52056,0,0,0,0,0,52056,0,0,0,0,0,0,0,11,0,'184000','184000',1

Re: BigInt with primary key

, which doesn't make sense at all. I'm surprised the insert even works. Thirdly, have you tried checktable/myisamcheck? - Original Message - From: "chchen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 18:56 Subject: BigInt with primary key hi all i

Re: BigInt with primary key

occur. i thought this first. but seems not ...isamchk -r, or -f even -c or -e can't find any error. then, i try delete the table and insert again. but it still will occur this error. I summary my question. that is my table use Bigint as a primary key, i insert/update this table from empty

Re: BigInt with primary key

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('9231852172526977164