Re: [sqlite] UPDATE SET using column-name-list Syntax error

Richard Hipp wrote: On 12/10/17, javaj1...@elxala.com wrote: According to the documentation UPDATE SET admits column-name-list as argument but I cannot get it working. Here some tries DROP TABLE IF EXISTS test; CREATE TABLE test(a,b,c); -- ok UPDATE test SET a = "vala", b = "valb" ; UPDATE te

Re: [sqlite] UPDATE SET using column-name-list Syntax error

>UPDATE test SET (a, b) = "vala", "valb" ; Should that not be (a, b) = (‘vala’, ‘valb’); >UPDATE test SET (a, b) = (SELECT "vala", "valb") ; Should that not be (a, b) = ((SELECT ‘vala’), ‘valb’); ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] UPDATE SET using column-name-list Syntax error

On 12/10/17, javaj1...@elxala.com wrote: > > According to the documentation UPDATE SET admits column-name-list as > argument > but I cannot get it working. Here some tries > > DROP TABLE IF EXISTS test; CREATE TABLE test(a,b,c); > > -- ok > UPDATE test SET a = "vala", b = "valb" ; > UPDATE test SE