[an error occurred while processing this directive]

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

                         

[an error occurred while processing this directive]