Retrieving last_insert_id

"Jerry Schwartz" <[email protected]> Fri, 21 Jan 2011 14:56:32 -0500

Newsgroups	gmane.comp.db.mysql.odbc
Organization	Global Information Inc.
Message-ID	<[email protected]>

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:[email protected]> [email protected] 

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