Geek Answers Handbook

Select last name for table in SQLite?

Am I looking for the equivalent of Scope_identity () or @@ identifier on sql server, except sqllite?

I would not want to resort to the maximum selection in the id column, but this is believable.

+5
source share
2 answers

Since I have never used SQL Server, I am not quite sure what it is doing @@IDENTITY, but if I understand this document correctly , then it sqlite3_last_insert_rowid()may be what you are looking for.

+5
source

last_insert_rowid ()

ROWID , . last_insert_rowid() SQL sqlite3_last_insert_rowid() C/++.

+3

More articles:


All Articles