Statistics/sandbox
From UFFL Wiki
Mad is using this sandbox to review a variety of ways data can be imported from the DDSPF2021 MDB file (via MySQL) into meaningful information for the Wiki.
IMPORTING PLAYER RECORDS
| Records | |||||
|---|---|---|---|---|---|
| Record ID | Week | Season | Team | Versus | Value |
| 1 | 16 | 2019 | 8 | 5 | 28 |
| 2 | 9 | 2021 | 2 | 15 | 100 |
| 4 | 14 | 2015 | 8 | 9 | 444 |
| 5 | 14 | 2015 | 8 | 9 | 5 |
| 3 | 6 | 2016 | 8 | 10 | 3 |
| 6 | 10 | 2018 | 8 | 6 | 150 |
| 7 | 8 | 2016 | 8 | 12 | 87 |
| 0 | 16 | 2019 | 8 | 5 | 43 |
| 5 | 0 | 2019 | 8 | 0 | 26 |
| 7 | 0 | 2016 | 8 | 0 | 87 |
| 6 | 0 | 2018 | 8 | 0 | 97 |
| 3 | 0 | 2016 | 8 | 0 | 14 |
| 4 | 0 | 2015 | 8 | 0 | 3955 |
| 2 | 0 | 2016 | 8 | 0 | 63 |
| 1 | 0 | 2015 | 8 | 0 | 322 |
| 0 | 0 | 2015 | 8 | 0 | 532 |
| 0 | 0 | 2015 | 8 | 5 | 40 |
| 1 | 0 | 2015 | 8 | 9 | 27 |
| 2 | 0 | 2015 | 8 | 12 | 72 |
| 4 | 0 | 2015 | 8 | 12 | 523 |
| 5 | 0 | 2015 | 8 | 9 | 4 |
| 3 | 0 | 2015 | 8 | 5 | 2 |
| 6 | 0 | 2015 | 8 | 9 | 128 |
| 7 | 0 | 2015 | 8 | 12 | 98 |
Issues: - Convert/teamid is not working on the TeamID and VsTeamID columns - I do not know yet how to make the RecordID field meaningful (each number corresponds to a record type, and it may change depending on player position)
