Closed SmileYzn closed 2 years ago
Use 'SQL_GetInsertId' to get last id insert
Use 'SQL_GetInsertId' to get last id insert
RETURNING is used to return any field not only id. Also RETURNING is available since sqlite 3.35 not older versions.
And SQL_GetInsertId maybe not work wtith sqlite
Ps. Sqlite 3.35 also has other improvements.
I understand what you mean, 'SQL_GetInsertId' works with sqlite too
Finally someone made a pull reques to this.
Help us help you
Environment
Description
Is possible to update SQLite in sqlite module?
There is some improvements and adjusts to match with mondern version of sqlite.
Ie. Some new RETURNING id (From INSERT INTO statement). That can be used in sqlite 3.35 or newer
insert into users (first_name, last_name) values ('Jane', 'Doe') returning id;
Thanks for work!