Type value | Type description |
tiny | TINYINT field |
short | SMALLINT field |
long | INTEGER field |
int24 | MEDIUMINT field |
longlong | BIGINT field |
decimal | DECIMAL or NUMERIC field |
newdecimal | Precision math DECIMAL or NUMERIC |
float | FLOAT field |
double | DOUBLE or REAL field |
bit | BIT field |
timestamp | TIMESTAMP field |
date | DATE field |
time | TIME field |
datetime | DATETIME field |
year | YEAR field |
string | CHAR or BINARY field |
var.string | VARCHAR or VARBINARY field |
blob | BLOB or TEXT field (use max.length to determine the maximum length) |
set | SET field |
enum | ENUM field |
geometry | Spatial field |
null | NULL-type field |