MySQL Forums
Forum List  »  Newbie

LAST INSERT ID
Posted by: felipe alvares
Date: September 26, 2007 08:31AM

When i use SELECT LAST_INSERT_ID(cd_Code) AS next FROM tb_Client
(note - cd_Code is autoincrement)

it shows all the records from cd_Code if i do LIMIT 1
it shows me the first one
how can i do for it to show me the last maximum record?
how can i do for it to show me the last record i inserted?

Options: ReplyQuote


Subject
Written By
Posted
LAST INSERT ID
September 26, 2007 08:31AM
September 26, 2007 01:37PM


Sorry, you can't reply to this topic. It has been closed.

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.