Get New MySQL ID

[RedBassett]

Whenever I use MySQL databases for anything PHP related, I set a primary key column with the name `id` and auto-increment on each table as a way of accessing everything easily.

My problem comes if I want to know what the auto-increment ID is when I run the insert command. Is there a way other than polling the table and guessing the next number to get what ID an insert command was assigned, without running a SELECT command on another column to find the last row just inserted?

[Bob]

Apr 5, 2010 14:03:19 GMT -8 RedBassett said:

Whenever I use MySQL databases for anything PHP related, I set a primary key column with the name `id` and auto-increment on each table as a way of accessing everything easily.

My problem comes if I want to know what the auto-increment ID is when I run the insert command. Is there a way other than polling the table and guessing the next number to get what ID an insert command was assigned, without running a SELECT command on another column to find the last row just inserted?

Use the mysql_insert_id () function.

[Charles Stover]

Very useful function. Does it work if you INSERT'd in a previous session, or can it only be used on the same page as the INSERT statement?

[Chris]

Apr 6, 2010 19:06:23 GMT -8 Charles Stover said:

Very useful function. Does it work if you INSERT'd in a previous session, or can it only be used on the same page as the INSERT statement?

To my knowledge, same session only. For others, you can just use something like

SELECT `id` FROM `table` ORDER BY `id` DESC LIMIT 1

(My syntax is rusty, so I apologize if that's wrong.)