I don't think so... That's not shown in the syntax diagram.
> -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] 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 <[email protected]> wrote: > > > From: Marc L. Allen <[email protected]> > > Subject: [sqlite] How efficient is this? > > To: "[email protected]" <[email protected]> > > 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 > > * > > > > * > > * > > * > > > > * > > * [email protected] > > * -- The Phantom > > Tollbooth * > > * > > * > > > > * > > ****************************************************************** > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
