且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

删除sqlite中表格的第一行

更新时间:2023-12-04 11:44:04

SQLite DELETE Query 用于从表中删除现有记录.您可以使用 WHERE 子句和 DELETE 查询来删除选定的行.否则,所有记录将被删除.

SQLite DELETE Query is used to delete the existing records from a table. You can use WHERE clause with DELETE query to delete the selected rows. otherwise, all the records would be deleted.

如果您需要删除 SQLite 上的前几行,此查询是一种简单的方法,但有多条记录超过 1000 条,请确保查询获取实际记录

If you need to delete the top rows on SQLite this query is a simple way, But there were multiple records more than 1000 make sure the query getting actual records

DELETE FROM images WHERE rowid in (select rowid FROM images LIMIT 1)