mysql如何去除两个字段数据相同的记录？

查询重复记录：

SELECT t.id, t.item_id
FROM eco_tb_item_info t
INNER JOIN (SELECT item_id
FROM eco_tb_item_info
GROUP BY item_id
HAVING COUNT(id) > 1) dup
ON t.item_id = dup.item_id

删除，只需要把你这张表当成两张表来处理就行了。

DELETE p1 from eco_tb_item_info  p1, eco_tb_item_info p2 WHERE p1.item_id= p2.item_id AND p1.id > p2.id;