diff options
Diffstat (limited to 'queries/player/count_player_matches.sql')
| -rw-r--r-- | queries/player/count_player_matches.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/queries/player/count_player_matches.sql b/queries/player/count_player_matches.sql index fbdd283..226cacc 100644 --- a/queries/player/count_player_matches.sql +++ b/queries/player/count_player_matches.sql @@ -25,3 +25,5 @@ select ) INSERT INTO player_stats(player_api_id, patch_version, played, wins, casual_played, casual_wins, ranked_played, ranked_wins, streak) SELECT * FROM stats +ON CONFLICT(player_api_id) DO + UPDATE SET (player_api_id, patch_version, played, wins, casual_played, casual_wins, ranked_played, ranked_wins, streak) = (SELECT * FROM stats) |