如果系统里面的数据都不是你想要的,那么就可以使用上面的sql语句清空,重新采集
记得操作之前一定要记得备份,一定要备份,备份,以免有问题可以随时恢复
1,赛事直播清空:
TRUNCATE TABLE phome_ecms_live; TRUNCATE TABLE phome_ecms_live_check; TRUNCATE TABLE phome_ecms_live_check_data; TRUNCATE TABLE phome_ecms_live_data_1; TRUNCATE TABLE phome_ecms_live_doc; TRUNCATE TABLE phome_ecms_live_doc_data; TRUNCATE TABLE phome_ecms_live_doc_index; TRUNCATE TABLE phome_ecms_live_index;
2,新闻资讯清空:
TRUNCATE TABLE phome_ecms_news; TRUNCATE TABLE phome_ecms_news_check; TRUNCATE TABLE phome_ecms_news_check_data; TRUNCATE TABLE phome_ecms_news_data_1; TRUNCATE TABLE phome_ecms_news_doc; TRUNCATE TABLE phome_ecms_news_doc_data; TRUNCATE TABLE phome_ecms_news_doc_index; TRUNCATE TABLE phome_ecms_news_index;
3,录像清空:
TRUNCATE TABLE phome_ecms_luxiang; TRUNCATE TABLE phome_ecms_luxiang_check; TRUNCATE TABLE phome_ecms_luxiang_check_data; TRUNCATE TABLE phome_ecms_luxiang_data_1; TRUNCATE TABLE phome_ecms_luxiang_doc; TRUNCATE TABLE phome_ecms_luxiang_doc_data; TRUNCATE TABLE phome_ecms_luxiang_doc_index; TRUNCATE TABLE phome_ecms_luxiang_index;
4,视频清空:
TRUNCATE TABLE phome_ecms_video; TRUNCATE TABLE phome_ecms_video_check; TRUNCATE TABLE phome_ecms_video_check_data; TRUNCATE TABLE phome_ecms_video_data_1; TRUNCATE TABLE phome_ecms_video_doc; TRUNCATE TABLE phome_ecms_video_doc_data; TRUNCATE TABLE phome_ecms_video_doc_index; TRUNCATE TABLE phome_ecms_video_index;
5,tag标签清空:
TRUNCATE `[!db.pre!]enewstags`; TRUNCATE `[!db.pre!]enewstagsclass`; TRUNCATE `[!db.pre!]enewstagsdata`;


