List:General Discussion« Previous MessageNext Message »
From:speters Date:September 19 2002 7:55pm
Subject:Replace query question
View as plain text  
If i use a replace query, and there isn't an error, then either
a new row was inserted, or an existing row was updated.

The primary key in the table i'm replacing to is defined as
mprid int not null auto_increment primary key

whether an insert or update actually occurs, i want to get the value of 
mprid that was affected.

if it's a new row, i assume i can use select last_insert_id()
but if its an update, will that work?

thanks,
sean peters
speters@stripped


Thread
Replace query questionspeters19 Sep
  • re: Replace query questionVictoria Reznichenko20 Sep