LAST_INSERT_ID SQL code example

Example 1: last insert id

$last_id = $conn->insert_id;

Example 2: 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;

Example 3: 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 %d\n", mysql_insert_id());
?>

Tags:

Php Example