Subject what the most efficient way to do update or insert with value ?
hello,

i want to do something like

update or insert into mytable(ID, amount) values (123, amount + 100);

how to do this ?