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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
In the LAST_INSERT_ID() documentation it says:
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.