benjam Posted October 13, 2006 Share Posted October 13, 2006 I have a chess script and I would like to add the total wins, draws, and losses collected in one instance (table) to the wins, draws, and losses collected in another instance (table).For instance:table 1 is like:playerp_idp_usernamep_winsp_drawsP_lossesand table 2 is like:wc2_playerp_idp_usernamep_winsP_drawsp_lossesI would like to add the wins from `player` into `wc2_player`, but only if the value for p_username is the same.Can I do this in one query? Both tables are in the same DB. Quote Link to comment Share on other sites More sharing options...
fenway Posted October 13, 2006 Share Posted October 13, 2006 Try the following (UNTESTED, so back up your DB!)[code]UPDATE wc2_player INNER JOIN player USING p_username SET wc2_player.p_wins += player.p_wins[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.