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, 1279👍, 0💬
Popular Posts:
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...