12 replies to this topic

[Hajjel]

How do I get the latest insert (by ID) from a table?

[WingedPanther]

Can you offer a few more details? Are you talking about an HTML table, a database table, something else?

[Hajjel]

WingedPanther said:

Can you offer a few more details? Are you talking about an HTML table, a database table, something else?

sry, a database table ofc :P

[WingedPanther]

With a database table, unless you are recording a timestamp value when the record is added, or using a trigger to log which is the most recent, you may not be able to.

[Hajjel]

WingedPanther said:

Can you offer a few more details? Are you talking about an HTML table, a database table, something else?

Can't I just get it from the largest ID? I save ID as int.

[BlaineSch]

Yes, if you want the largest ID it is possible

Quote

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

[chili5]

You can sort it and grab it by ID, however, there might be some performance problems when you do this with a lot of data. Perhaps, a slightly better thing to do is store when the record was inserted and do this:

SELECT * FROM table_name WHERE time_stamp = MAX('time')

:) Though, I don't know if this is any better. I just see problems with sorting the entire table when you have A LOT of data.

[Orjan]

if you're in mysql, you can use mysql_insert_id() if you use auto_increment as primary key... but it's not always reliable, as it is the very last query done, so if someone else does another insert, you might get that one instead....

[Orjan]

ah okey, it's at least connection sensitive. but anyways. you can't do two inserts in a row and expect to have the first insert's id from the mysql_insert_id.

[sastro]

Quote

you can't do two inserts in a row and expect to have the first insert's id from the mysql_insert_id

Is it possible with innoDB?

[Orjan]

according to mysql documentation, there is no stated exceptions for any database types