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

Reply via email to