why mysql last insert id 0 code example

Example: mysql set last_insert_id

SET @last_id = LAST_INSERT_ID();