SQL/MySQL/Data Type/Data Type Summary

Data Types in MySQL

   <source lang="sql">

+---------------------+------------------+-------------------------+----------------+ | Numbers | Text | Date and Time | Defined Group | +---------------------+------------------+-------------------------+----------------+ | Integers: INT, | Normal strings: | Date and time: DATETIME |Enumerated lists:| | TINYINT, | CHAR | | ENUM | SMALLINT, | | | | | MEDIUMINT,| | | | | BIGINT | | | | +---------------------+------------------+-------------------------+----------------+ | Fixed decimals: |Variable strings: | Date and time: TIMESTAMP|Sets of similar | | NUMERIC, DECIMAL | VARCHAR | | data: SET | +---------------------+------------------+-------------------------+----------------+ |Floating point: |Long text: | Date only: DATE | | | FLOAT, DOUBLE | TINYTEXT, | | | | | MEDIUMTEXT, | | | | | TEXT, | | | | | LARGETEXT | | | +---------------------+------------------+-------------------------+----------------+ | | Binary Long | Time only: TIME | | | | Objects: BLOB, | | | | | TINYBLOB, | | | | | MEDIUMBLOB, | | | | | LONGBLOB | | | +---------------------+------------------+-------------------------+----------------+ | | |Year only: YEAR | | +---------------------+------------------+-------------------------+----------------+

      </source>