如果系统里面的数据都不是你想要的，那么就可以使用上面的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`; TRUNCATE `[!db.pre!]dp_itag`;
