| Subject | Re: [firebird-support] what the most efficient way to do update or insert with value ? |
|---|---|
| Author | Helen Borrie |
| Post date | 2012-02-15T09:02:23Z |
>> i want to do something likeAt 09:22 PM 15/02/2012, Elmar Haneke wrote:
>>
>> update or insert into mytable(ID, amount) values (123, amount + 100);
>>
>> how to do this ?
>Have a look atWon't work for this. Use MERGE.
>http://www.firebirdsql.org/refdocs/langrefupd21-update-or-insert.html
./heLen