Tags

, , , , , , , , , , , , , , , , , , , , , ,

TINYINT
A very small integer
The signed range is –128 to 127. The unsigned range is 0 to 255.

SMALLINT
A small integer
The signed range is –32768 to 32767. The unsigned range is 0 to 65535

MEDIUMINT
A medium-size integer
The signed range is –8388608 to 8388607. The unsigned range is 0 to 16777215

INT or INTEGER
A normal-size integer
The signed range is –2147483648 to 2147483647. The unsigned range is 0 to 4294967295

BIGINT
A large integer
The signed range is –9223372036854775808 to 9223372036854775807.
The unsigned range is 0 to 18446744073709551615

FLOAT
A small (single-precision) floating-point number. Cannot be unsigned
Ranges are –3.402823466E+38 to –1.175494351E-38, 0 and 1.175494351E-38 to 3.402823466E+38.
If the number of Decimals is not set or <= 24 it is a single- precision floating point number

DOUBLE, DOUBLE PRECISION, REAL
A normal-size (double-precision) floating-point number. Cannot be unsigned
Ranges are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0 and 2.2250738585072014E-308 to 1.7976931348623157E+308.
If the number of Decimals is not set or 25 <= Decimals <= 53 stands for a double-precision floating point number

DATE
A date
The supported range is ‘1000-01-01’ to ‘9999-12-31’.
MySQL displays DATE values in ‘YYYY-MM-DD’ format.
Format can be changed.

DATETIME
A date and time combination
The supported range is ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’.
MySQL displays DATETIME values in ‘YYYY-MM-DD HH:MM:SS’ format
Format can be changed

TIMESTAMP
A timestamp
The range is ‘1970-01-01 00:00:00’ to sometime in the year 2037.
MySQL displays TIMESTAMP values in YYYYMMDDHHMMSS, YYMMDDHHMMSS, YYYYMMDD or YYMMDD etc..

TIME
A time
The range is ‘-838:59:59’ to ‘838:59:59’.
MySQL displays TIME values in ‘HH:MM:SS’ format, but allows you to assign values to TIME columns using either strings or numbers

YEAR*
A year in 2- or 4- digit formats (default is 4-digit)
The allowable values are 1901 to 2155, and 0000 in the 4 year format and 1970-2069 if you use the 2 digit format (70-69).
MySQL displays YEAR values in YYYY format, but allows you to assign values to YEAR columns using either strings or numbers

CHAR
A fixed-length string that is always right-padded with spaces to the specified length when stored
The range of Length is 1 to 255 characters. Trailing spaces are removed when the value is retrieved.
CHAR values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given

VARCHAR
A variable-length string. Note: Trailing spaces are removed when the value is stored
The range of Length is 1 to 255 characters.
VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given

TINYBLOB, TINYTEXT
A BLOB or TEXT column with a maximum length of 255 (2^8 – 1) characters

BLOB,TEXT
A BLOB or TEXT column with a maximum length of 65535 (2^16 – 1) characters

MEDIUMBLOB, MEDIUMTEXT
A BLOB or TEXT column with a maximum length of 16777215 (2^24 – 1) characters

LONGBLOB, LONGTEXT
A BLOB or TEXT column with a maximum length of 4294967295 (2^32 – 1) characters

ENUM
An enumeration
A string object that can have only one value, chosen from the list of values ‘value1’, ‘value2’, …, or NULL.
An ENUM can have a maximum of 65535 distinct values.

SET
A set
A string object that can have zero or more values, each of which must be chosen from the list of values ‘value1’, ‘value2’, …
A SET can have a maximum of 64 members

Advertisements