opensubscriber
   Find in this group all groups
 
Unknown more information…

m : myodbc@lists.mysql.com 22 January 2011 • 3:56AM -0500

Retrieving last_insert_id
by Jerry Schwartz

REPLY TO AUTHOR
 
REPLY TO GROUP




I have an auto_increment field in my table, but I need to set another field to the same value. (Please don’t ask why.)



It seems I would need to insert the record, and then update it; but I haven’t figured out how to get the value of last_insert_id().



Any ideas?



Regards,



Jerry Schwartz

Global Information Incorporated

195 Farmington Ave.

Farmington, CT 06032



860.674.8796 / FAX: 860.674.8341

E-mail:  <mailto:jerry@gii....> jerry@gii....

Web site:  <http://www.the-infoshop.com/> www.the-infoshop.com




Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

Related Messages

opensubscriber is not affiliated with the authors of this message nor responsible for its content.