| 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 question | speters | 19 Sep |
| • re: Replace query question | Victoria Reznichenko | 20 Sep |
