I have a table into which new data is frequently inserted. I need to get the very last ID of the table. How can I do this?
Is it similar to
SELECT MAX(id) FROM table?
If you're using PDO, use
If you're using Mysqli, use
If you're still using Mysql:
Please, don't use
mysql_*functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.
But if you have to, use
there is a function to know what was the last id inserted in the current connection
mysql_query('INSERT INTO FOO(a) VALUES(\'b\')'); $id = mysql_insert_id();
plus using max is a bad idea because it could lead to problems if your code is used at same time in two different sessions.
That function is called mysql_insert_id