Retrieve last inserted id from a table

Question

I have a table that I would like to retrieve and display the next auto-increment 'id' attribute.

$id = mysql_insert_id(); works AFTER insert. Though I want to display this information without inserting anything.

What would be the best way to do this?

You can select the largest id, and then +1 – iatboy Nov 10 '14 at 07:16 — iatboy, Nov 10 '14 at 07:16
get $id = mysql_insert_id()+1; – Nikhil Vaghela Nov 10 '14 at 07:17 — Nikhil Vaghela, Nov 10 '14 at 07:17

score 3 · Accepted Answer · edited Nov 10 '14 at 07:51

3

You can try SELECT MAX(ID) FROM table_name

edited Nov 10 '14 at 07:51

Carlos

answered Nov 10 '14 at 07:22

Priyank

score 0 · Answer 2 · answered Nov 10 '14 at 07:23

0

You can try something like this,

EXAMPLE

SELECT id+1 as YOUR_LAST_INSERTED_ID FROM `example_table` order by id desc limit 1

answered Nov 10 '14 at 07:23

Dimag Kharab

2 Answers2