FMDB/SQLite 删除前N条数据的SQL

2023-06-07 本文已影响0人 Accepted_

例如删除前50条数据

delete from table_name where id in (select id from table_name order by id ASC limit 50);