Re: BigInt with primary key

2001-02-20 Thread Eric Pickup
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

Re: BigInt with primary key

2001-02-20 Thread Fred van Engen
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

Re: BigInt with primary key

2001-02-20 Thread chchen
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" <[EMAIL PROTECTED]>

Re: BigInt with primary key

2001-02-20 Thread Rolf Hopkins
, 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

BigInt with primary key

2001-02-20 Thread chchen
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),'9231