代码1：

DELETE t1

FROM qb_cms_content1 t1

JOIN qb_cms_content1 t2 ON t1.title = t2.title

WHERE t1.id > t2.id;

DELETE t1

FROM qb_cms_content t1

JOIN qb_cms_content t2 ON t1.title = t2.title

WHERE t1.id > t2.id;

代码2：

-- 删除表qb_cms_content1中的重复记录  

DELETE FROM qb_cms_content1  

WHERE title IN (  

    SELECT title  

    FROM qb_cms_content1  

    GROUP BY title  

    HAVING COUNT(*) > 1  

);  

-- 删除表qb_cms_content中的重复记录  

DELETE FROM qb_cms_content  

WHERE title IN (  

    SELECT title  

    FROM qb_cms_content  

    GROUP BY title  

    HAVING COUNT(*) > 1  

);