2 ms·
Agreed that it should return the updated count automatically, but it's possible to get that amount by pairing it with a query for the rowid of that new record:
by Apocryphon 9y ago
Agreed that it should return the updated count automatically, but it's possible to get that amount by pairing it with a query for the rowid of that new record:
https://www.sqlite.org/c3ref/last_insert_rowid.html https://www.sqlite.org/c3ref/last_insert_rowid.html
And if it's a table with autoincrement primary key, try:
https://stackoverflow.com/a/2217015/223327 https://stackoverflow.com/a/2217015/223327