Re: Can insert update a table based on match of one column value?

[Peter Brawley]

3 queries in a transaction, eg in an sproc ...

start transaction
select ... where readstatus=true for update;
if found_rows() > 0 then update ... set ...;
else insert ... set ...
end if;
commit;