Get last inserted rowid from sqlite database

最新推荐文章于 2024-08-20 17:01:38 发布

最新推荐文章于 2024-08-20 17:01:38 发布 · 222 阅读

文章标签：

#数据库 #c/c++

Android 同时被 2 个专栏收录

180 篇文章

订阅专栏

SQLite

4 篇文章

订阅专栏

本文介绍如何在SQL中使用last_insert_rowid()函数获取最新插入行的ID，包括使用AUTOINCREMENT关键字时查询SQLITE_SEQUENCE表来获取表级别的ID。详细解释了ROWID的概念，以及如何在特殊情况下访问它，特别注意与用户定义的同名列的区别。

Use

SELECT last_insert_rowid();

to get the last inserted rowid. If you are using AUTOINCREMENT keyword then

SELECT * from SQLITE_SEQUENCE;

will tell you the values for every table.

last_insert_rowid

last_insert_rowid()

The last_insert_rowid() function returns the ROWID of the last row insert from the database connection which invoked the function. The last_insert_rowid() SQL function is a wrapper around the sqlite3_last_insert_rowid() C/C++ interface function.

rowid

Every row of every SQLite table has a 64-bit signed integer key that uniquely identifies the row within its table. This integer is usually called the "rowid". The rowid value can be accessed using one of the special case-independent names "rowid", "oid", or "_rowid_" in place of a column name. If a table contains a user defined column named "rowid", "oid" or "_rowid_", then that name always refers the explicitly declared column and cannot be used to retrieve the integer rowid value.