From eff50fabbc1928864e1087727a5fe85f1bb2de0f Mon Sep 17 00:00:00 2001 From: MichaƂ Date: Mon, 24 Apr 2017 14:17:16 +0200 Subject: Update useful-sql.md --- docs/useful-sql.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'docs') 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 -- cgit v1.2.3