So I was needed to find some duplicate records in a table that had more than 3,000 records. I stumbled upon this query which made my life easier.
SELECT `field`, COUNT(`field`)
FROM `table`
GROUP BY `field`
HAVING ( COUNT(`field`) > 1 )
-
‹ Home
Contents
-
Categories
-
Tags
>2TB /etc/rc.conf : ? Areca bash programming bourne again shell core dumps count csh duplicate FreeBSD+php5+php5-extensions FreeBSD 6.2 FreeBSD ports g_vfs_done(): having mysql Order allow order deny php.core ports restart sendmail search and replace Segmented Fault sendmail_enable sh shell programming shell tests signal 11 start sendmail stop sendmail tcsh ternary
-
Archives
-
RSS Feeds
-
Meta