Data Type

Character

• CHAR(size), * VARCHAR(size)

• TINYTEXT, TEXT(size), MEDIUMTEXT, LONGTEXT

• TINYBLOB, BLOB(size), MEDIUMBLOB, LONGBLOB

• BINARY(size), VARBINARY(size)

• ENUM(val1, val2, val3, ...), * SET(val1, val2, val3, ...)

Number

• BIT(size), BOOL, BOOLEAN

• TINYINT(size), SMALLINT(size), MEDIUMINT(size), INT(size), INTEGER(size), BIGINT(size)

• FLOAT(size, d), FLOAT(p), DOUBLE(size, d), DOUBLE PRECISION(size, d)

• DECIMAL(size, d), DEC(size, d)

Date

• DATE

• DATETIME

• TIMESTAMP

• TIME

• YEAR