数据库操作语句

轻热点

ims_pb_hot_v2_integration_collection_articles轻热点---采集的文章内容

DELETE FROM `ims_pb_hot_v2_integration_collection_articles` WHERE `ims_pb_hot_v2_integration_collection_articles`.`id` < 17928

DELETE FROM `ims_pb_hot_v2_tasks_record` WHERE `ims_pb_hot_v2_tasks_record`.`id` <= 17146

DELETE FROM `ims_pb_hot_v2_tasks_error_record` WHERE `ims_pb_hot_v2_tasks_error_record`.`id`<= 19856

ims_pb_hot_v2_core_attachment（视频相关）可能已经废弃

DELETE FROM `ims_pb_hot_v2_core_attachment` WHERE `ims_pb_hot_v2_core_attachment`.`id` = 312580

注：七牛/videos/pb_hot/6/

ims_pb_hot_v2_core_attachment文章系统-素材库

DELETE FROM `ims_pb_hot_v2_core_attachment` WHERE `ims_pb_hot_v2_core_attachment`.`createtime` <= 1604160000

ims_pb_hot_v2_tasks_record

DELETE FROM `表名` WHERE `表名`.`字段名` <1;

DELETE FROM `ims_pb_hot_v2_tasks_record` WHERE `ims_pb_hot_v2_tasks_record`.`id` <1;