SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
gives the same info (in recent MySqls) and can be filtered;
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
gives the same info (in recent MySqls) and can be filtered;
if for example, you want to apply a unique index, but you can’t because there’s duplicates in the table.
SELECT name FROM mytable GROUP BY name HAVING COUNT(*) > 1;