why last_insert ID returns 0 ?
Posted by: Karen Goh
Date: December 23, 2018 11:04PM

I'd like to check a MYSQL query :

SELECT LAST_INSERT_ID() FROM hi5.tutor

Can I know what is wrong with this statement cos it returns a O whereas there are many IDs in the tutor table.

Tks.

Options: ReplyQuote


Subject
Written By
Posted
why last_insert ID returns 0 ?
December 23, 2018 11:04PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.