Check fo dups

[Mike Gagnon]

Anyone know how to check for duplicates on MySql with VFP?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[zhavic]

I thing the same way as with MSSQL an VFP, the ANSI SQL can be used for that

Example: this returns count of duplicate records by giver criteria in GROUP BY clause

SELECT COUNT(*) FROM your_table GROUP BY some_column_or_columns_or_expressions HAVING COUNT(*) > 1

It depends of what you are want to return:
List of duplicate records or only test if there are some duplicate records in table by given criteria.
Or you want to search duplicates by all columns ? e.g. find full duplicated rows ?

Zhavic


---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.

 

[Mike Gagnon]

COUNT(*)

It seems mySQL does like that.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.