Tipe Data:
- Tipe Data Number
- Tipe Data Number
- Tipe Data Number
1. Tipe Data Number
Dibagi menjadi 2 Tipe data Integer, Floating Point, dan Decimal
Tabel Tipe Data Integer
Type |
Length in Bytes |
Minimum Value (Signed) |
Maximum Value(Signed) |
Minimum Value(Unsigned) |
Maximum Value(Unsigned) |
TINYINT |
1 |
-128 |
127 |
0 |
255 |
SMALLINT |
2 |
-32768 |
32767 |
0 |
65535 |
MEDIUMINT |
3 |
-8388608 |
8388607 |
0 |
16777215 |
INT |
4 |
-2147483648 |
2147483647 |
0 |
4294967295 |
BIGINT |
8 |
-9223372036854775808 |
9223372036854775807 |
0 |
18446744073709551615 |
Tabel Tipe Data Floating Point
Type |
Length in Bytes |
Minimum Value (Signed) |
Maximum Value(Signed) |
Minimum Value(Unsigned) |
Maximum Value(Unsigned) |
FLOAT |
4 |
-3.402823466e+38 |
-1.175494351e-38 |
1.175494351e-38 |
3.402823466e+38 |
DOUBLE |
8 |
-1.7976931348623157E+308 |
-2.2250738585072014E-308 |
0 & 2.2250738585072014E-308 |
1.7976931348623157E+308 |
Signed: value dapat bernilai negatif.
Unsigned: value hanya bernilai positif.
Length in Bytes: ukuran memory yang dipakai untuk menyimpan tipe data tersebut di hardisk. Contoh: ketika menyimpan tipe TINYINT di hardisk, maka hardisk kalian akan berkurang 1 Bytes.
Tabel Tipe Data Decimal
DECIMAL |
MIN |
MAX |
DECIMAL(3,2) |
-9.99 |
9.99 |
DECIMAL(7,5) |
-99.99999 |
99.99999 |
DECIMAL(3,0) |
-999 |
999 |
DECIMAL(3) |
-999 |
999 |
Top comments (0)