MySQL Data types

Last Updated: 28 May, 2023

MySQL supports a wide variety of data types that can be used to define columns in tables. Here are the most commonly used data types:

Numeric Types:

1. INT: A standard integer type that can store signed integers from -2147483648 to 2147483647.
2. BIGINT: A larger integer type that can store signed integers from -9223372036854775808 to 9223372036854775807.
3. FLOAT: A floating-point number type that can store single-precision values.
4. DOUBLE: A floating-point number type that can store double-precision values.
5. DECIMAL: A fixed-point number type that can store exact values.

Date and Time Types:

1. DATE: A date type that stores values in the format of "YYYY-MM-DD".
2. TIME: A time type that stores values in the format of "HH:MM:SS".
3. DATETIME: A combined date and time type that stores values in the format of "YYYY-MM-DD HH:MM:SS".
4. TIMESTAMP: A timestamp type that stores values in the format of "YYYY-MM-DD HH:MM:SS".

String Types:

1. CHAR: A fixed-length string type that can store up to 255 characters.
2. VARCHAR: A variable-length string type that can store up to 65535 characters.
3. TEXT: A large text type that can store up to 65535 characters.
4. BLOB: A binary large object type that can store up to 65535 bytes of data.

Other Types:

1. BOOLEAN: A boolean type that can store true or false values.
2. ENUM: A list type that can store one value from a set of predefined values.
3. SET: A list type that can store one or more values from a set of predefined values.