[MySQL] Proper way to do player statistics?
#3

If you're planning to create another table, only put the UserID in there, along with Stat ID and the value.
The user's name should already be in your Users table.
There is no need to copy it to every other table where a UserID is located, a player's name should only exist 1 time in your entire database.

If there are many statistics, you might find it useful to use another table for it.
If it's less than 15 or so, just include them in the Users table.
Reply


Messages In This Thread
[MySQL] Proper way to do player statistics? - by Type-R - 09.02.2017, 05:02
Re: [MySQL] Proper way to do player statistics? - by saffierr - 09.02.2017, 06:52
Re: [MySQL] Proper way to do player statistics? - by AmigaBlizzard - 09.02.2017, 07:41
Re: [MySQL] Proper way to do player statistics? - by JesterlJoker - 09.02.2017, 07:45
Re: [MySQL] Proper way to do player statistics? - by Vince - 09.02.2017, 08:45
Re: [MySQL] Proper way to do player statistics? - by Type-R - 09.02.2017, 13:51
Re: [MySQL] Proper way to do player statistics? - by Astralis - 09.02.2017, 15:07
Re: [MySQL] Proper way to do player statistics? - by Type-R - 09.02.2017, 17:09

Forum Jump:


Users browsing this thread: 1 Guest(s)