mysql return id after insert – 2 ways to insert and return id mysql

mysql return id after insert : Get ID of The Last Inserted Record. The best WAY to get the id is by using mysql_insert_id() or the mysql SQL function LAST_INSERT_ID().

mysql return id after insert

using LAST_INSERT_ID() function

You need to use the LAST_INSERT_ID() function:

INSERT INTO table_name (col1, col2,...) VALUES ('val1', 'val2'...);
SELECT LAST_INSERT_ID();

mysql id of inserted row

get id of record created php

<?php
$servername = "localhost";
$username = "root";
$password = "[email protected]";
$dbname = "pakainfo_v1";

// Make connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO Members (firstname, lastname, email_address)
VALUES ('Ravi', 'Rak', '[email protected]')";

if (mysqli_query($conn, $sql)) {
    $last_id = mysqli_insert_id($conn);
    echo "New Members created successfully. your Last Members inserted ID is: " . $last_id;
} else {
    echo "some Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>

Don’t Miss : Laravel MySQL Get Last Inserted ID

mysql get last inserted id

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

-- using a command in C# use: --
int lastId = (Int32)yourCommand.LastInsertedId;

I hope you get an idea about mysql return id after insert.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.