--+
1 row in set (0.00 sec)
mysql>
--- On Wed, 3/2/11, Johan De Meersman wrote:
From: Johan De Meersman
Subject: Re: Two Identical Values on Primary Key Column
To: "Rodrigo Ferreira"
Cc: mysql@lists.mysql.com
Date: Wednesday, March 2, 2011, 11:21 AM
#yiv704254679 p {margin:0;}
Is it possible that someone did an alter table disable keys at some point,
maybe for a bulk load, and forgot to re-enable them ?
- Original Message -
> From: "Rodrigo Ferreira"
> To: mysql@lists.mysql.com
> Sent: Wednesday, 2 March, 2011 3:04:31 PM
> Subject: T
Hi all,
I have just experienced a strange problem with mysql production database. The
table faqsessions have a primary key on column `Code` and the above select
return 2 rows!
mysql>
mysql>
mysql> show create table faqsessions;
+-+
