phpsqlsqlitefunctionlastinsertid

How to get last insert Id in SQLite?


Is there any built in function available in SQLite to fetch last inserted row id. For eg :- In mysql we have LAST_INSERT_ID() this kind of a function. For sqllite any function available for doing the same process.

Please help me.

Thanks


Solution

  • SQLite

    This is available using the SQLite last_insert_rowid() function:

    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.

    PHP

    The PHP version/binding of this function is sqlite_last_insert_rowid():

    Returns the rowid of the row that was most recently inserted into the database dbhandle, if it was created as an auto-increment field.