sqlite基本操作,历史记录大于10条自动删除

sqlite基本操作。当历史记录超过10条时,会自动删除多余的记录。 代码示例: ```java delete from user where (select count(id) from user ) > 9 and id in (select id from user order by id desc limit (select count(id) from user) offset 9); ```
zip 文件大小:2.48MB