Overview of Core Data Types

• Integer types: TINYINT, SMALLINT, MEDIUMINT, INT/INTEGER, BIGINT
• Floating-point types: FLOAT, DOUBLE
• Fixed-point types: DEC(M,D), DECIMAL(M,D)
• Bit types: BIT(M)

Date and Time Data Types

Date and time types in MySQL include: DATE, DATETIME, TIMESTAMP, TIME, YEAR

String Data Types

String types in MySQL include: CHAR, VARCHAR, BINARY, VARBINARY, ENUM