Aptarimas:MySQL duomenų tipai

SMALLINT[(M)] [UNSIGNED] [ZEROFILL], -32768 to 32767, UNSIGNED: 0 to 65535 MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL], -8388608 to 8388607, UNSIGNED: 0 to 16777215 INT[(M)] [UNSIGNED] [ZEROFILL], -2147483648 to 2147483647, 0 to 4294967295 INTEGER[(M)] [UNSIGNED] [ZEROFILL], tas pats kaip ir INT BIGINT[(M)] [UNSIGNED] [ZEROFILL], -9223372036854775808 to 9223372036854775807, UNSIGNED 0 18446744073709551615 SERIAL, tas pats kaip ir BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE FLOAT[(M,D)] [UNSIGNED] [ZEROFILL], -3.402823466E+38 to -1.175494351E-38, 0, ir 1.175494351E-38 iki 3.402823466E+38 DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL], -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308 DOUBLE PRECISION[(M,D)] [UNSIGNED] [ZEROFILL], REAL[(M,D)] [UNSIGNED] [ZEROFILL] FLOAT(p) [UNSIGNED] [ZEROFILL] DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL] DEC[(M[,D])] [UNSIGNED] [ZEROFILL], NUMERIC[(M[,D])] [UNSIGNED] [ZEROFILL], FIXED[(M[,D])] [UNSIGNED] [ZEROFILL], tas pats kaip ir DECIMAL

Eilučių tipai

BINARY(M)