Numeric Data Types:
| TINYINT( ) | -128 to 127 normal 0 to 255 UNSIGNED. |
| SMALLINT( ) | -32768 to 32767 normal 0 to 65535 UNSIGNED. |
| MEDIUMINT( ) | -8388608 to 8388607 normal 0 to 16777215 UNSIGNED. |
| INT( ) | -2147483648 to 2147483647 normal 0 to 4294967295 UNSIGNED. |
| BIGINT( ) | -9223372036854775808 to 9223372036854775807 normal 0 to 18446744073709551615 UNSIGNED. |
| FLOAT | A small number with a floating decimal point. |
| DOUBLE( , ) | A large number with a floating decimal point. |
| DECIMAL( , ) | A DOUBLE stored as a string, allowing for a fixed decimal point. |
Date Data Types:
| DATE | YYYY-MM-DD. |
| DATETIME | YYYY-MM-DD H:MM:SS. |
| TIMESTAMP | YYYYMMDDHHMMSS. |
| TIME | HH:MM:SS. |
MISC Types
| ENUM ( ) | ENUMERATION means that each column may have one of specified possible values. |
| SET | SET is similar to ENUM. However, SET can have up to 64 list items and it can store more than one choice |
TEXT TYPES
| CHAR( ) | Fixed section from 0 to 255 characters long. |
| VARCHAR( ) | Variable section from 0 to 255 characters long. |
| TINYTEXT | String with a maximum length of 255 characters. |
| TEXT | String with a maximum length of 65535 characters. |
| BLOB | String with a maximum length of 65535 characters. |
| MEDIUMTEXT | String with a maximum length of 16777215 characters. |
| MEDIUMBLOB | String with a maximum length of 16777215 characters. |
| LONGTEXT | String with a maximum length of 294967295 characters. |
| LONGBLOB | String with a maximum length of 4294967295 characters. |