Red Gate MySQL Compare showing similar objects shown in the differences group

Question

I am doing a MySQL Red Gate schema compare and there are objects being shown in the differences group, but the compare view shows no differences. Am I missing something?

Did you choose all columns in when comparing them? – Joshua Drake Apr 10 '12 at 20:51 — Joshua Drake, Apr 10 '12 at 20:51

score 0 · Answer 1 · edited Jul 18 '12 at 04:31

0

Try the following:

SELECT 
    phone, 
    COUNT(phone) AS NumOccurrences
FROM 
    *MyTable*
GROUP BY 
    phone
HAVING ( 
    COUNT(phone) > 1 
)

edited Jul 18 '12 at 04:31

Robert

8,717
2
27
34

answered Apr 11 '12 at 09:37

Voislav Sauca

3,007
2
18
12

Red Gate MySQL Compare showing similar objects shown in the differences group

1 Answers1