In MySql how do I query a table to see if one column has two similar entries of another column?

Asked Feb 20 '19 at 15:31

Active Feb 20 '19 at 15:38

Viewed 33 times

Let's say I have a table called CAT

CAT has two columns ID and NAME

I forgot to add a unique constraint for these two columns.. and in my database I want to make sure I don't have any wrong entries before I add that constraint.

So I want a query to make sure every ID has unique values in the NAME column. How can I query for this?

edited Feb 20 '19 at 15:38

Shadow

32,277
10
49
61

asked Feb 20 '19 at 15:31

RonApple1996

`SELECT COUNT(*) cnt FROM cat GROUP By name HAVING cnt > 1` – Alex Feb 20 '19 at 15:40
@Alex this is the solution described in the answers to the duplicate questions... – Shadow Feb 20 '19 at 15:49

In MySql how do I query a table to see if one column has two similar entries of another column?

0 Answers0