You could do this with a map instead of a list.
*CREATE TABLE movie (*
* id text,*
* name text,*
* ratings map,*
* PRIMARY KEY ( id )*
*);*
*UPDATE movie SET ratings['bob'] = 5 WHERE id = 'terminator 3';*
--
Michael Mior
michael.m...@gmail.com
2016-10-24 18:16 GMT-04:00 Ali Akhtar
On 24 October 2016 at 22:16, Ali Akhtar wrote:
> *UPDATE movie set ratings.rating = 5 WHERE ratings.user = 'bob'*
You won't be able to do this because you're trying to update a row without
specifying the primary key. Also, even if you did add the PK to the where,
you've