Re: [sqlite] Is this a proper syntax?

[Igor Tandetnik]

On 10/24/2013 7:34 PM, Igor Korot wrote:
So I was thinking of something like this:
UPDATE leagueplayers SET original_rank = (SELECT rank FROM players AS a),
current_rank= a WHERE players.playerid = leagueplayers.playerid;

But I guess this query will not work. ;-)

Any idea how to make the proper query?

I can't think of anything better than

UPDATE leagueplayers SET
   original_rank = (SELECT rank FROM players WHERE players.playerid = 
leagueplayers.playerid),
   current_rank = (SELECT rank FROM players WHERE players.playerid = 
leagueplayers.playerid);

Or two statements:

UPDATE leagueplayers SET
   original_rank = (SELECT rank FROM players WHERE players.playerid = 
leagueplayers.playerid);
UPDATE leagueplayers SET current_rank = original_rank;

--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users