[TM] LAST_INSERT_ID not working

[Pierre SULPICE]

Hello,

It seems like this always returns 0 :
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_last-insert-id

For the following reason probably (quote from Stackoverflow)
The problem seemed to be in MySQL's phpmyadmin config file PersistentConnections set to FALSE which resulted in a new CONNECTION_ID every time a query was issued - therefore rendering SELECT LAST_INSERT_ID() ineffective.

Is there a way tog et the ID of the last inserted row ?
I'm doing a "full" select after my insert now, it's not ideal

Thanks,
Best regarsd,

[Joseph Benguira]

Hey Pierre,

This must be done in the same transaction, please check this tutorial about it:
https://support.appdrag.com/blog/63-Inserting-a-Row-in-the-Database--Create-New-Row-Id.html?category=13