Hi,
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 ?
I am specially interested in the syntax using SELECT since it could
optimize the update
reducing the number of needed SELECT's
thanks,
Alejandro
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
