| CHAR |
String (0-255), can store characters of fixed length |
CHAR(50) |
| VARCHAR |
String (0-255), can store characters up to given length |
VARCHAR(50) |
| BLOB |
String (0-65535), can store characters up to given length |
VARCHAR(50) |
| INT |
Integer (-2, 147, 483 to 2, 147, 483, 647) |
INT |
| TINYINT |
Integer (-128 to 127) |
TINYINT |
| BIGINT |
Integer (-9, 223, 372, 036, 854, 775, 808 to 9, 223, 372, 036, 854, 775, 807) |
BIGINT |
| BIT |
Can store x-bit values x can range from 1 to 64 |
BIT(2) |
| FLOAT |
Decimal number -with precision to 23 digits |
FLOAT |
| DOUBLE |
Decimal number -with precision to 24 to 53 digits |
DOUBLE |
| BOOLEAN |
Boolean values 0 or 1 |
BOOLEAN |
| DATE |
Date in format of YYYY-MM--DD ranging from 1000-01-01 to 9999-12-31 |
DATE |
| YEAR |
Year in 4 digits format ranging from 1901 to 2155 |
YEAR |