MySQL Column Type Database

In this session you will learn how to support number of column in MySQL . MySQL supports the numeric type , Date and time type, and String type (char) database.

MySQL Column Type Database

MySQL Column Type Database

     

In this session you will learn how to support number of column in MySQL . MySQL supports the numeric type , Date and time type, and String type (char) database.

MySQL Numeric type and String type Database :

  TYPE BYTE  MINIMUM VALUE MAXIMUM VALUE
TINYINT  1 Byte -128 127
BIT (M+7)/8 Byte   - -
SMALLINT 2 Byte -32768 32767
MEDIUMINT 3 Byte -8388608 8388607
INT(M) (UNSIGNED) (ZEROFILL) 4 Byte -2147483648 2147483647
INTERGER [M] 4 Byte  - -
BIGINT [M] 8 Byte -9223372036854775808 9223372036854775807
FLOAT [precision] 4 Byte
FLOAT [(M, D)] 8 Byte
DOUBLE [(M,D)] 8 Byte
DOUBLE precision [(M, D)] 8 Byte  -1.7976931348623157E+308 to-2.2250738585072014E-308, 0, 2.2250738585072014E-308 to 1.7976931348623157E+308
REAL [(M, D)] 8 Byte 
DECIMAL [(M ,D)] M+2 Byte  -999.99 999.99
NUMERIC[(M,D)] M+2 Byte 
VARCHAR  L+1 Byte  0 255
CHAR M Byte  0 255
TINYBLOB L+1 Byte  0 256
TINYTEXT L+1 Byte  0 255  (2^8-1) Char 
BLOB OR TEXT L+2 Byte   0  65,535 (2^16-1)char 
MEDIUMBLOB  L+3 Byte  - 16,777,215(2^24-1)char
MEDIUMTEXT L+3 Byte  - 16,777,215(2^24-1)char
LONGBLOB L+4 Byte   - 4,294,967,295(2^32-1)char
LONGTEXT L+4 Byte   - 4,294,967,295 or 4GB
ENUM ('value1, value2',..) 1 or  2 Byte  65,535
SET ('value1,' value 2,' .....) 1 to 8 Byte 0 64

MySQL Store the Date and Time Type

  Column Type     Store Data
DATE 3 Byte
DATETIME 8 Byte
TIMESTAMP 4 Byte
TIME 3 Byte
YEAR 1 Byte