Is it safe to use LAST_INSERT_ID() in a system using MySQL like Point Of Sale when there are multiple users using the system at the same time?
In the LAST_INSERT_ID() documentation it says:
The ID that was generated is maintained in the server on a
per-connection basis. This means that the value returned by the
function to a given client is the first AUTO_INCREMENT value generated
for most recent statement affecting an AUTO_INCREMENT column by that
client. This value cannot be affected by other clients, even if they
generate AUTO_INCREMENT values of their own. This behavior ensures
that each client can retrieve its own ID without concern for the
activity of other clients, and without the need for locks or
transactions.
So, if you call that function just after the insert to know the ID you inserted, it shouldn’t be affeted by other concurrent users, as they are not using the same connection.
Anyway, there is not much detail in your question, so maybe your use case is a bit more complex than that.
6