To add to what Jaime said, UPSERT VALUES will update an existing row too if
the row already exists.
On Saturday, September 5, 2015, Jaime Solano <jdjsolano@gmail.com> wrote:
> Hi Bipin,
> You can use the UPSERT SELECT statement.
> https://phoenix.apache.org/language/#upsert_select
> Best,
> -Jaime
> On Sep 4, 2015 11:10 PM, "Bipin Nag" <bipin.nag@gmail.com
> <javascript:_e(%7B%7D,'cvml','bipin.nag@gmail.com');>> wrote:
>
>> How can I update values in an existing row. I believe the upsert
>> statement does not take a where clause. How to do update ?
>>
>> Thanks
>> Bipin
>>
>
|