mysql两个字段数据相同
SELECT
t1.*
FROM
table t1
JOIN table t2 ON t1.id != t2.id
AND t1.field1= t2.field1
AND t1.field2= t2.field2
删除两个相同字段数据
DELETE FROM table where id in(SELECT id from (
SELECT
t1.id
FROM
table t1
JOIN table t2 ON t1.id != t2.id
AND t1.field1= t2.field1
AND t1.field2= t2.field2)as temp)