使用前提:假设我的日志表叫 t_interactive_log其id 是个bigint类型字段
DELETE
FROM
t_interactive_log
WHERE
id not IN (
SELECT
*
FROM
(
SELECT
id
FROM
t_interactive_log
WHERE
_rowid >10000
ORDER BY
visit_time DESC
) x
)