| Subject | Re: [firebird-support] what the most efficient way to do update or insert with value ? |
|---|---|
| Author | Elmar Haneke |
| Post date | 2012-02-15T08:22:34Z |
> i want to do something likeHave a look at
>
> update or insert into mytable(ID, amount) values (123, amount + 100);
>
> how to do this ?
http://www.firebirdsql.org/refdocs/langrefupd21-update-or-insert.html