How to implement getting the id of the last record of the table and put it in another?

Question

SQL

There is a database in which 2 tables, the first table (Users) stores data about registered users, the second database (devise) contains the result of their actions. How to get the id of the last registered user and add it to the devise table??

Answer 1

last_insert_rowid() - www.sqlite.org/lang_corefunc.html#last_insert_rowid