数据库操作语句-飞鱼工作室

轻热点

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` <= 40749

//删除表ID小于等于40749的数据

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

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

注:七牛/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;

RIPRO主题是一个优秀的主题,极致后台体验,无插件,集成会员系统
飞鱼工作室 » 数据库操作语句

提供最优质的资源集合

立即查看 了解详情