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);
```
2.48MB
文件大小:
评论区