帝国CMS系统后台批量删除不带标题图片信息

  • 执行SQL语句删除不带标题图片的信息:
    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);
  • 在后台“系统 - 数据备份与恢复 - 执行SQL语句”中执行。
  • 执行前务必备份数据,以防数据丢失。
wx.jpg ywfw.jpg
热门