title: Saving Rankings in MySQL
body: <p>I am planning on calculating regional and global rankings once everyday. There will be multiple rankings, each based on ratings or stats.</p>
  
  <p>What would be the best way to save these player rankings? Will it be better to create a table for each individual stat with each row containing playerID, regional rank and global rank, or create a single ranking table with lots of columns? The second option will lead to some rows having empty columns because a player might not have that specific stat.</p>
  
  <p>Also, what would be the most efficient way to save the daily rankings to be able to create a graph that will show a player's progress? If I decide not to create a graph, I will just delete the table(s) before creating a new one.</p>