MySQL field value range

MySQL field value range

TINYINT

-128-127

TINYINT UNSIGNED

0-255

SMALLINT

-32768-32767

SMALLINT UNSIGNED

0-65535

MEDIUMINT

-8388608-8388607

MEDIUMINT UNSIGNED

0-16777215

INT or INTEGER

-2147483648-2147483647

Int unsigned or INTEGER UNSIGNED

0-4294967295

BIGINT

-9223372036854775808-9223372036854775807

BIGINT UNSIGNED

0-18446744073709551615

FLOAT

-3.402823466E + 38--1.175494351E-38

0

1.175494351E-38-3.402823466E + 38

DOUBLE, double precision, or REAL

-1.7976931348623157E + 308--2.225074255072014e-308

0

2.225074255072014e-308-1.7976931348623157E + 308

DECIMAL [(M, [D])] or NUMERIC (M, D)

It is determined by M (the length of the entire number, including the decimal point, the number of digits on the left of the decimal point, the number of digits on the right of the decimal point, but not the negative number) and D (the number of digits on the right of the decimal point, M is 10 by default, D is 0 by default

DATE

1000-01-01-9999-12-31

DATETIME

1000-01-01 00:00:00-9999-12-31 23:59:59

TIMESTAMP

2037 00:00:00-one day in December (I don't know which day, huh, huh)

TIME

-838: 59: 59' to 838: 59: 59

YEAR [(2 | 4)]

The default format is 4 bits. The value range of 4 bits is 1901-1970, 2069, and the value range of 2 bits is 70-69)

CHAR (M) [BINARY] Or NCHAR (M) [BINARY]

M ranges from 1 to 255. If BINARY is not available, it is case-insensitive. NCHAR indicates that the default character set is used. fill in space in the database, but the space at the end of the removal will be automatically removed.

[NATIONAL] VARCHAR (M) [BINARY]

M ranges from 1 to 255. spaces at the end of the database will be removed automatically.

TINYBLOB or TINYTEXT

255 (2 ^ 8-1) characters

BLOB or TEXT

65535 (2 ^ 16-1) characters

MEDIUMBLOB or MEDIUMTEXT

16777215 (2 ^ 24-1) characters

LONGBLOB or LONGTEXT

4294967295 (2 ^ 32-1) characters

ENUM ('value1 ', 'value2 ′,...)

There can be a total of 65535 different values

SET ('value1', 'value2 ′,...)

 

Up to 64 members