mysql_insert_id functionality about mysql HOT 4 CLOSED

i've had a look at this and i can get around it by issuing a SELECT LAST_INSERT_ID() in the callback from the query but am not sure if i am guaranteed to get the correct result as another insert could theoretically be run before this on the same connection... no?

from mysql.

that call will return the last insert ID for this connection, so you need to be careful about contention

the actual insert_id, along with affected_rows is returned in the command success packet, so we should be able to pull it out.

ref: http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#OK_Packet

[edit] it's passed as part of the packet sent to the 'end' event on the query as packet.insertId. packet.affectedRows is also available

from mysql.

I just added an FAQ entry for this here: c5540bf

Let me know if you have more questions!

from mysql.

great - thanks felix

from mysql.