MySQL Values - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Values (/showthread.php?tid=621297)

---

MySQL Values - Micko123 - 09.11.2016

Can someone explain me when should I use these when setting up MySQL tables

Tinyint
Smallint
Mediumint
Int
Bigint

??

---

Re: MySQL Values - Threshold - 09.11.2016

http://dev.mysql.com/doc/refman/5.7/...ger-types.html

---

Re: MySQL Values - Micko123 - 09.11.2016

So according to this tinyint is just enough for almost everything??

---

Re: MySQL Values - Vince - 09.11.2016

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.

---

Re: MySQL Values - Micko123 - 09.11.2016

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...

---