I don't think so... That's not shown in the syntax diagram.
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Sebastian Bermudez > Sent: Thursday, March 08, 2012 11:43 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] How efficient is this? > > > you can do: > update t1 set (a,b)=(select a, b from t2 where t1.id=t2.id) > > just like oracle do.... > > > > > --- On Thu, 3/8/12, Marc L. Allen <mlal...@outsitenetworks.com> wrote: > > > From: Marc L. Allen <mlal...@outsitenetworks.com> > > Subject: [sqlite] How efficient is this? > > To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> > > Date: Thursday, March 8, 2012, 12:53 PM I'm trying to do a > > multi-column update, adding values from another table. Something > > like: > > > > UPDATE t1 SET a += (SELECT a FROM t2 WHERE t1.id = t2.id), > > > > b += > > (SELECT b FROM t2 WHERE t1.id = t2.id); > > > > Note that both a and b are updated from the a and b of the same > > record. (Or it's supposed to be that way, ignoring any syntax errors > > from above.) Does SQLite really do two lookups? Is there a more > > efficient way of doing this? > > > > Thanks, > > > > Marc > > > > -- > > ****************************************************************** > > * > > * > > > > * > > * Marc L. Allen > > * "... so many things are > > * > > * > > * > > possible just as long as you * > > * Outsite Networks, Inc. * don't know they're impossible." * > > * (757) 853-3000 #215 > > * > > > > * > > * > > * > > > > * > > * mlal...@outsitenetworks.com > > * -- The Phantom > > Tollbooth * > > * > > * > > > > * > > ****************************************************************** > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
