数据库操作语句

轻热点

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;

发表回复