如何获取主键字段的最后插入值？

Question

I am using MySQL.I have to get the last inserted record's primary key value. How can i get this?

Answer 1

This will return the last inserted id.

SELECT LAST_INSERT_ID();

OR

if ((result = mysql_store_result(&mysql)) == 0 &&
    mysql_field_count(&mysql) == 0 &&
    mysql_insert_id(&mysql) != 0)
{
    used_id = mysql_insert_id(&mysql);
}