List:MySQL ODBC« Previous MessageNext Message »
From:Jerry Schwartz Date:January 21 2011 7:56pm
Subject:Retrieving last_insert_id
View as plain text  
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@stripped> jerry@stripped 

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

 



Thread
Retrieving last_insert_idJerry Schwartz21 Jan
  • RE: Retrieving last_insert_idJohn Bonnett2 Feb
    • RE: Retrieving last_insert_idJerry Schwartz3 Feb
  • RE: Retrieving last_insert_idAl McNicoll3 Feb
    • RE: Retrieving last_insert_idJerry Schwartz3 Feb
      • RE: Retrieving last_insert_idAl McNicoll3 Feb
        • RE: Retrieving last_insert_idLawson K. Cronlund3 Feb
        • RE: Retrieving last_insert_idJerry Schwartz3 Feb
  • Re: RE: Retrieving last_insert_idpwr3 Feb
    • RE: RE: Retrieving last_insert_idJerry Schwartz3 Feb