Collections:
Retrieving the Last Sequence ID in MySQL
How To Get the Last ID Assigned by MySQL in MySQL?
✍: FYIcenter.com
If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below:
<?php
include "mysql_connection.php";
$sql = "INSERT INTO fyi_users (name)"
. " VALUES ('John King')";
if (mysql_query($sql, $con)) {
print(mysql_affected_rows() . " rows inserted.\n");
print("Last ID inserted: ".mysql_insert_id()."\n");
} else {
print("SQL statement failed.\n");
}
mysql_close($con);
?>
If you run this script, you will get something like this:
1 rows inserted. Last ID inserted: 3
⇒ Storage Engines: MyISAM, InnoDB and BDB in MySQL
⇐ Define the ID Column as Auto-Incremented in MySQL
2017-09-12, 3177🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...