Mysql Data types

Numeric Data Types:

⊕ INT               - A normal-sized integer that can be signed or unsigned.

⊕ TINYINT      - A very small integer that can be signed or unsigned. 

⊕ SMALLINT   - A small integer that can be signed or unsigned. 

⊕ MEDIUMINT - A medium-sized integer that can be signed or unsigned. 

⊕ BIGINT         - A large integer that can be signed or unsigned. 

⊕ FLOAT          - A floating-point number that cannot be unsigned. 

⊕ DOUBLE        - A double precision floating-point number that cannot be unsigned. 

⊕ DECIMAL       - An unpacked floating-point number that cannot be unsigned. 

Date and Time Data Types:

⊕ DATE             - A date in YYYY-MM-DD format.

⊕ DATETIME     - A date and time combination in YYYY-MM-DD HH:MM:SS format.

⊕ TIMESTAMP - A timestamp between midnight.

⊕ TIME             - Stores the time in HH:MM:SS format.

⊕ YEAR            - Stores a year in 2-digit or 4-digit format. 

String Data Types:


⊕ CHAR           - A fixed-length string between 1 and 255 characters in length.

⊕ VARCHAR    - A variable-length string between 1 and 255 characters in length; 

⊕ BLOB or TEXT - A field with a maximum length of 65535 characters. 

⊕ TINYBLOB or TINYTEXT - A BLOB or TEXT column with a maximum length of 255 characters.

⊕ MEDIUMBLOB or MEDIUMTEXT - A BLOB or TEXT column with a maximum length of 16777215 characters. 

⊕ LONGBLOB or LONGTEXT - A BLOB or TEXT column with a maximum length of 4294967295 characters. 

⊕ ENUM - An enumeration, which is a fancy term for list.