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, 1460🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...