insert into tablename (column1,column2...) values (value1,value2...)
select last_insert_rowid()
select primaryKey from table name where rowid = last_insert_rowid()
sqlite插入数据后如何获得插入数据的主键
最新推荐文章于 2021-05-27 10:17:54 发布
insert into tablename (column1,column2...) values (value1,value2...)
select last_insert_rowid()
select primaryKey from table name where rowid = last_insert_rowid()