BEGIN
-- 保留最新100条
DELETE FROM LAST WHERE rowid IN (
SELECT rowid FROM LAST ORDER BY rowid ASC LIMIT ((
SELECT CASE WHEN (
SELECT COUNT(*) FROM LAST)-100> 0 THEN (
SELECT COUNT(*) FROM LAST)-100 ELSE 0 END)));
END
SQLITE触发器表保留最新的N条记录
最新推荐文章于 2024-08-07 13:50:02 发布