On 9 May 2010, at 8:41pm, Simon Hax wrote: > I think in sqlite the following is not possible: > > update T > set (a,b,c) = ( select x,y,z from ...) > > Does anyone know how to do in an easy way ?
Do your SELECT first, then set the multiple variables to the values retrieved from that: UPDATE T SET a=x,b=y,c=z WHERE ... Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users