delete phome_ecms_news from phome_ecms_news, (select id from phome_ecms_news group by title having count(*)>1 ) as t2 where phome_ecms_news.id=t2.id

執行完成以上命令,還要執行一下 下面的語句來修正 副表.

delete from 'phome_ecms_news_index' where id not in(select id from phome_ecms_news)//開源軟件:Vevb.com

以上命令執行完即可,也可以用以下的命令修正副表 ID 錯誤,用以下命令進入 PHPMYADMIN 管理多于的錯誤 ID:

SELECT id FROM phome_ecms_news_data_1 WHERE NOT EXISTS (SELECT null FROM phome_ecms_news WHERE phome_ecms_news.id = phome_ecms_news_data_1.id);