我的知识记录

delete from [表前缀]_ecms_news where titlepic = ''; delete from [表前缀]_ecms_news_index where id not in (select id from [表前缀]_ecms_news); delete from [表前缀]_ecms_news_data_1 where id not in (select id from [表前缀]_ecms_news);