获取SQLite上最后一行的ID的最佳方法-BestwaytogettheIDofthelastinsertedrowonSQLite

59  

If you can guarantee that your ID column is an auto-increment column, MAX(ID) is fine.

如果您可以保证您的ID列是自动增量列，MAX（ID）就可以了。

But to cover any case, there's a specialized SQLite function called LAST_INSERT_ROWID():

但是要涵盖任何情况，都有一个名为LAST_INSERT_ROWID（）的专用SQLite函数：

SELECT LAST_INSERT_ROWID();

In FMDB, you use the -lastInsertRowId method (which internally runs the above):

在FMDB中，您使用-lastInsertRowId方法（在内部运行上面的方法）：

int lastId = [fmdb lastInsertRowId];

8  

The function sqlite3_last_insert_rowid() is what you're looking for. Having just checked out the source code for FMDB, there seems to be a method on FMDatabase called -lastInsertRowId that wraps the function.

函数sqlite3_last_insert_rowid（）就是你要找的。刚刚检查了FMDB的源代码，FMDatabase上似乎有一个名为-lastInsertRowId的方法来包装该函数。

0  

Try the following:

请尝试以下方法：

var rowid: Int = Int(contactDB.lastInsertRowId())