LAST_INSERT_ID() returns the latest ID for the current connection. As
long as you yourself can guarantee that no other queries are executed
using that connection, you're fine. If another record others is inserted
using another connection, that connection will return a different
LAST_INSERT_ID()
If I insert a record into a table with an auto increment ID how can I get
that records ID value? I have read about SELECT LAST_INSERT_ID() statement,
however, do not two statements introduce the risk that another insert may
occur in the interum? Is there a full proof way of getting the ID of the
re