PHP和Mysqli - 多个查询合二为一？

Question

I need to get the ID (a column) from the last row inserted, in a table. I'm wondering if there's any way to somehow embed that in another query, to avoid having two different querys? It seems much simpler, and i believe i've seen it somewhere before.

Something like this:

$query = "INSERT INTO a_table (x, y) VALUES ((SELECT id FROM another_table ORDER BY id DESC), 'y...')";

Any ideas how to do that? Thanks.

Answer 1

If you're looking to get the newest record created by your script, you should never do it this way in the first place. What if another instance of your script created a record at the same time?

mySQL's LAST_INSERT_ID() will return the last ID created over this specific connection. However, you must call it immediately after your insert statement.

If getting the highest ID is literally what you want, GSto's answer will work for you.