On 12/10/17, [email protected] <[email protected]> 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 SET a = (SELECT "vala"), b = (SELECT "valb") ; > > -- not ok > UPDATE test SET (a, b) = "vala", "valb" ; > Error: near "(": syntax error > UPDATE test SET (a, b) = (SELECT "vala", "valb") ; > Error: near "(": syntax error > > What am I doing wrong ? or is this syntax really supported ?
It is supported beginning with SQLite 3.15.0 (2016-10-14). What version of SQLite are you running? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
