A more direct way to find dupes ...
SELECT id, COUNT( id ) AS cnt,
FROM myTable
GROUP BY id
HAVING cnt > 1
PB
----- Original Message -----
From: Paul McNeil
To: MySQL General
Sent: Tuesday, July 06, 2004 9:30 AM
Subject: Create Temporary Table, incorrect rows
Good day to all.
I have a table and want to find duplicate info in the table. I know
duplicated info exists by running the following...
Select count(*) from myTable -> 141123
Select distinct(myData) from myTable -> 1411000
So I created a temporary table to store distinct records and want to do a
join with original table to see what records are duplicates.
Create Temporary Table A
Select distinct(mydata),rowID from myTable;
When I run this it says that the temp table has only 1000 rows. Why?
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
