Tipe Data MySQL - Bahasa Indonesia

Tipe Data:

1. Tipe Data Number
2. Tipe Data Number
3. 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