How to make SELECT LAST_INSERT_ID() as id work?

Question

MySQL

SELECT LAST_INSERT_ID() as id
returns 0 all the time, although it should return the ID of the newly added entry

Answer 1

Firstly, the request is not complete, the table is not specified, and secondly, if an auto index is used, then it is easier to make a selection by id.
For example,

SELECT id FROM tbl_name ORDER BY id DESC LIMIT 0, 1