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, which doesn't make sense
at all. I'm surprised the insert even works.
Thirdly, have you tried checktable/myisamcheck?
----- Original Message -----
From: "chchen" <s8553105@stripped>
To: <mysql@stripped>
Sent: Tuesday, February 20, 2001 18:56
Subject: 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,'1
84000','184000',1),'9231898557453533324',0,0,5532,0,0,0,0,0,5532,0,0,0,0,0,0
,0,11,0,'184000','184000',1),'9230422383529723532',147,0,0,0,0,0,0,0,147,0,0
,0,0,0,0,0,91,0,'184000','184000',1) query failed
Duplicate entry '9231898557453533324' for key 1
but actually if i select * from Table where a='9231898557453533324'
it can't find anything.........what's wrong with this, bug?
p.s. unsigned Bigint should be from 0 to 18446744073709551615, so
'9231898557453533324' is included in it, right?
regards
Allen
