mysql find duplicate

mysql_duplicate.txt

SELECT a.phone, b.phone, a.companyId , b.companyId , a.id,b.id
FROM member a, member b
WHERE a.phone = b.phone 
AND a.companyId = b.companyId
AND a.id <> b.id


SELECT phone, COUNT(*) c FROM member GROUP BY phone HAVING c > 1;

SELECT GROUP_CONCAT(companyId), phone, COUNT(*) c FROM member GROUP BY phone HAVING c > 1;




INSERT INTO mytable (uid,`session`,counting,`type`,ft,isFilter ) SELECT uid,`session`,counting,`type`,ft,isFilter FROM mytableother WHERE id = 1


for mysql 8
login as root
ALTER USER 'myuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'my password';