去除term重复的记录:
DELETE FROM tag WHERE id IN
(SELECT id FROM (SELECT MIN(id) AS id,COUNT(term) AS COUNT FROM tag GROUP BY term
HAVING COUNT >1 ORDER BY COUNT DESC) AS tab )
去除term重复的记录:
DELETE FROM tag WHERE id IN
(SELECT id FROM (SELECT MIN(id) AS id,COUNT(term) AS COUNT FROM tag GROUP BY term
HAVING COUNT >1 ORDER BY COUNT DESC) AS tab )