查询重复记录:
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;