Queries

mysql.sql

##Select duplicate key on an column in mysql table with count
SELECT name, COUNT(*) c FROM CAT GROUP BY name HAVING c > 1;

## Simple table join queries
select a.* from CAT a,TAX b where b.name like '%Tax%' and a.PARENT_TAX_PKEY=b.pkey;

## Safe mode update Enable / Disable
SET SQL_SAFE_UPDATES = 0;

## Delete duplicate name records and keep lowest id record
DELETE n1 FROM CAT n1, CAT n2 WHERE n1.PKEY < n2.PKEY AND n1.name = n2.name;