Hi Chris,
On 3/24/2015 10:07 AM, Chris Hornung wrote:
Thanks for the suggestions regarding non-printing characters, definitely
makes sense as a likely culprit!
However, the data really does seem to be identical in this case:
mysql> select id, customer_id, concat('-', group_id, '-') from
app_cu
Thanks for the suggestions regarding non-printing characters, definitely
makes sense as a likely culprit!
However, the data really does seem to be identical in this case:
mysql> select id, customer_id, concat('-', group_id, '-') from
app_customergroupmembership where customer_id ='ajEiQA';
+
Please do
select id, customer_id, concat('-', group_id, '-')
from app_customergroupmembership
where customer_id ='ajEiQA';
I suspect one of those group IDs has a trailing space or similar 'invible'
character that makes it not identical.
- Original Message -
> From: "Chris
- Original Message -
From: "A Z" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 21, 2004 10:02 AM
Subject: Duplicate Rows
>
>
> MySQL 4.0.14
>
> In a scenario:
>
> Ref EmailAddr
>
> 1[EMAIL PROTECTED]
> 2[EMAIL PROTECTED]
> 3[EMAIL PRO
