Answers for "LAST_INSERT_ID()"

mysql set last_insert_id

SET @last_id = LAST_INSERT_ID();

last insert id

$last_id = $conn->insert_id;

mysql get last inserted id

-- To get the last inserted auto-increment row ID: --
SELECT LAST_INSERT_ID( optional_expression )

-- If you have just inserted it using a command in C# use: --
int lastId = (Int32)yourCommand.LastInsertedId;

last_insert_id() php

<?php
// use mysql_insert_id():
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) { die('Impossible de se connecter : ' . mysql_error()); }
mysql_select_db('mydb');
mysql_query("INSERT INTO mytable (product) values ('something')");
printf("last inserted id is %dn", mysql_insert_id());
?>