| Type : | Value : |
|---|---|
| INT | An integer -2147848648 to 2147848648 |
| DECIMAL | A floating point number that can specify the number of permissible digits. For Example : DECIMAL(5,2) permits -999.99 to 999.99 |
| DOUBLE | A long double-precision floating point number |
| DATE | A date in the YYY-MM-DD format |
| TIME | A time in the HH:MM:SS format |
| DATETIME | A combined date and time in the format YYYY-MM-DD HH:MM:SS |
| YEAR | A year 1901-2155 in either YY or YYYY format |
| TIMESTAMP | Automatic date and time of the last record entry |
| CHAR() | A string of a defined fixed length up to 255 characters long. For example CHAR(100) pads a smaller string to make it 100 characters long. |
| VARCHAR() | A string of variable length up to 255 characters long that is stored without padding |
| TEXT | A string up to 65535 characters long |
| BLOB | A binary type for variable data |
| ENUM | A single string value from a defined list. For example SET ( "red" , "green" , "blue" ) allows an entry of any one or more of these colours. |
| SET | A string or multiple strings from a defined list For example : SET ( "red" , "green" , "blue" ) allows an entry of any one or more of these colours. |