Numeric data types

Integers

• TINYNINT(M) M = possible length of the integer
• INT
• BOOLEAN: a special integer

Decimals

• DOUBLE(M, D) D = number of digits following decimal point

String data types

Variable-length strings

• VARCHAR(M)

Binary Large OBject

• BLOB
• LONGBLOB
• Bob Loblaw

Date and Time data types

• DATE MySQL stores dates as YYYY-MM-DD

• DATETIME Can be precise to 6 decimal points as YYYY-MM-DD HH:MM:SS[.fraction]

• YEAR Four-digit year