Hatem’s Diaries

Just a small tips to find duplicated fields in database :

SELECT id,field,count(*) as c FROM `tablename` group by field having c>1

We always set unique or index fields that we don’t want them to duplicate, but if you want to do some reports or maintenance this is a great way.

Tags: No Tags