How to delete last row if I have a `auto increment` field also

Question

I want to delete the last row of table.

Query:

delete from NEXG.user_type where `id`=last_insert_id()

id is auto increment key.

But it is showing 0 rows affected.

What is the reason behind this?

Answer 1

SIMPLY:

DELETE FROM `user_type` 
ORDER BY `id` DESC
LIMIT 1