diff options
| author | Michał <emkael@tlen.pl> | 2017-04-24 14:17:16 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-04-24 14:17:16 +0200 |
| commit | eff50fabbc1928864e1087727a5fe85f1bb2de0f (patch) | |
| tree | 4d1314e2a327afefb6bd9a631cee324bf9c84cab | |
| parent | 42a6749d599adfadf4a51cf17a9bb8b00d19a4e4 (diff) | |
Update useful-sql.md
| -rw-r--r-- | docs/useful-sql.md | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/docs/useful-sql.md b/docs/useful-sql.md index 32a8f5b..64de128 100644 --- a/docs/useful-sql.md +++ b/docs/useful-sql.md @@ -13,7 +13,7 @@ After importing ranking CSV to `temp_rankings`, copy to `rankings` with current ``` INSERT INTO rankings ( - SELECT pid, `date`, place, score, region, flags \ + SELECT pid, `date`, place, score, region, flags FROM temp_rankings JOIN players ON players.id = temp_rankings.pid |