MySql删除重复数据并保留一条
DELETE FROM tbl_1 WHERE id NOT IN( SELECT id FROM ( SELECT min(id) AS id FROM
tbl_1
GROUP BY `duplicate_id` ) a )
DELETE FROM tbl_1 WHERE id NOT IN( SELECT id FROM ( SELECT min(id) AS id FROM
tbl_1
GROUP BY `duplicate_id` ) a )