MySQL
MySQL . MySQL Oracle.
.
:
M - . 255 .
D - , . 30 , , M-2.
('[' ']') .
TINYINT[(M)] [UNSIGNED]
. -128 127. 0 255.
BIT, BOOL
TINYINT(1).
SMALLINT[(M)] [UNSIGNED]
. -32768 32767. 0 65535.
MEDIUMINT[(M)] [UNSIGNED]
. -8388608 8388607. 0 16777215.
INT[(M)] [UNSIGNED]
. -2147483648 2147483647. 0 4294967295.
FLOAT[(M,D)] [UNSIGNED]
. : -3,402823466E+38 -1,175494351E-38, 0, 1,175494351E-38 3,402823466E+38. UNSIGNED, . M , D - , . FLOAT FLOAT(X), X <=24 .
DOUBLE[(M,D)] [UNSIGNED]
. : -1,7976931348623157E+308 -2,2250738585072014E-308, 0, 2,2250738585072014E-308 1,7976931348623157E+308. UNSIGNED, . M , D - , . DOUBLE FLOAT(X), 25 <= X <= 53 .
DATE
. '1000-01-01' '9999-12-31'. MySQL DATE 'YYYY-MM-DD'.
DATETIME
. '1000-01-01 00:00:00' '9999-12-31 23:59:59'. MySQL DATETIME 'YYYY-MM-DD HH:MM:SS'.
TIME
. '-838:59:59' '838:59:59'. MySQL TIME 'HH:MM:SS'.
YEAR[(2|4)]
( ). : 1901 2155, 0000 1970-2069 (70-69). MySQL YEAR YYYY.
|
|
()
[NATIONAL] CHAR(M) [BINARY]
, . M 0 255 . . BINARY, CHAR .
NATIONAL CHAR ( NCHAR) ANSI SQL , CHAR (CHARACTER).
[NATIONAL] VARCHAR(M) [BINARY]
. M 0 255 . BINARY, VARCHAR .. VARCHAR CHARACTER VARYING.
TINYBLOB, TINYTEXT
BLOB TEXT 255 (2^8 - 1) .
BLOB, TEXT
BLOB TEXT 65535 (2^16 - 1) .
MEDIUMBLOB, MEDIUMTEXT
BLOB TEXT 16777215 (2^24 - 1) .