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, 1582🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...