DELETE FROM t_send_log WHERE id IN ( SELECT * FROM ( SELECT id FROM t_send_log WHERE _rowid > 10000 ORDER BY visit_time DESC ) x )
仅保留最新,最近的10000条日志 ,这条语句作用删除 多余的日志(mysql)日志表你自己定义 _rowid关键字是核心技巧
最新推荐文章于 2022-04-20 17:01:41 发布
DELETE FROM t_send_log WHERE id IN ( SELECT * FROM ( SELECT id FROM t_send_log WHERE _rowid > 10000 ORDER BY visit_time DESC ) x )