[thelist] [MySQL] return values from query

Paul Bennett paul at teltest.com
Thu Feb 13 17:54:01 CST 2003

Is there a way to return a field value from an insert query? Instead of
(1) inserting a new record and then (2) a select to get the match of the
new record and get the row id from the query (auto increment, primary
key), is there a way I can INSERT the new record and get mysql to tell
me the row_id value without querying a second time?

Paul Bennett
Internet Developer
Teltest Electronic Design
Phone : 64 4 237 0767
Web : http://www.teltest.com
Wap : http://wap.teltest.com
Email : paul at teltest.com

More information about the thelist mailing list