Posts: 1,199
Threads: 238
Joined: Feb 2016
Reputation:
0
Can someone explain me when should I use these when setting up MySQL tables
Tinyint
Smallint
Mediumint
Int
Bigint
??
Posts: 1,199
Threads: 238
Joined: Feb 2016
Reputation:
0
So according to this tinyint is just enough for almost everything??
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
I don't know how you define "almost everything". I think I've only ever used it to store car colors because that size is just right.
Posts: 1,199
Threads: 238
Joined: Feb 2016
Reputation:
0
For admin I've put value 2.
For score value 6
For money value 10
For deaths value 6
For kills value 6
For VIP value 2
And should I put there tinyint??
And did I made mistake at assigning values??
Beacuse I've been told that values goes like this
Max money: 999999999
Valuse is : 123456789
But I've put it 10 just to be secure...