Comments on: MySQL: Find Duplicate Entries in a Table

By: Derek

Derek — Wed, 04 Mar 2009 07:14:41 +0000

I think the code should be:

SELECT 
	id, report_id, count(*)
FROM
	proforma
GROUP BY
	id, report_id
HAVING
	count(*)>1

By: Nadab

Nadab — Tue, 22 Jul 2008 12:08:00 +0000

hi all, Few days back i was looking for mysql administrative tool. i came across sqlyog which has super cool features like data sync, migration from various like access, sql server with much more powerful tools. I was very impressed with the GUI and also their multiple databases connections. Just have a look into it !!!

By: Luke Maciak

Luke Maciak — Fri, 21 Sep 2007 02:44:56 +0000

Actually, this is a whole separate problem since all proformas have unique filenames associated with them. So checking for duplicate entries submitted under wrong report ID is always a wild card search.

And this is actually one of the problems that is a 100% end user problem, and can be easily fixed by the office staff without involving the IT.

By: Ricardo

Ricardo — Thu, 20 Sep 2007 01:52:40 +0000

Isn’t it also the case of having multiple of the same proforma with different ids?

In that case, you would need to identify columns that would have the value and compare them, like this:

SELECT
id, report_id, title, date
FROM
proforma p1, proforma p2
where
p1.title = p2.title
and p1.date = p2.date
and p1.report_id = p2.report_id
and p1.id p2.id

Since you said this is a 1-1 relationship, there shouldn’t be no results from this query.