sqlite3如何删除指定行数据?(如要删除数据表中第五行数据),请高手赐教!谢谢

2024-11-17 01:41:26
推荐回答(4个)
回答1:

删除tmp表第五行数据
delete from tmp where rowid in(select rowid from tmp limit 1 offset 4);

回答2:

delete from admin_power_title where rowid="5"

回答3:

一般需要有唯一标识列

回答4:

i don't know