Getting INSERTed valued of serial field
I thought I saw this answered somewhere but I cannot find the post, not sure why it's not popping in the search engine...
Anyway, I do an INSERT to a table which the primary key is a auto_increment column, how do I get the value of this column after the INSERT? Informix had a function DBINFO("sqlca.sqlerrd1") which would return this value. Anything similar in MySQL?
Subject
Views
Written By
Posted
Getting INSERTed valued of serial field
4980
July 07, 2005 06:57AM
2406
July 07, 2005 08:41AM
2199
July 07, 2005 10:40AM
2166
July 07, 2005 12:05PM
2361
July 07, 2005 12:43PM
2448
July 07, 2005 12:56PM
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.