如何使用 mysql 检索最后插入的 id - How to retrive the last inserted id using mysql?

How to retrive the last inserted id using mysql?

 SELECT event.event_name, restaurants.res_name 
 FROM event_choices
 INNER JOIN restaurants
 ON event_choices.res_id = restaurants.res_id
 INNER JOIN event
 ON event_choices.event_id = event.event_id

我正在尝试根据此查询带回所有记录event_id获取最后插入的记录。

类似于mysql_insert_id()会做的事情。

是否可以修改查询以仅返回上次插入的记录？

我的数据看起来像这样，我需要返回最后一个event_id及其匹配res_id

event_id  | res_id
116       | 1
116       | 2

SELECT event.event_name, restaurants.res_name 
FROM event_choices
INNER JOIN restaurants ON event_choices.res_id = restaurants.res_id
INNER JOIN event ON event_choices.event_id = event.event_id 
WHERE event.event_id = (SELECT MAX(event_id) FROM event)