Data Types in MySQL
|
|
|
+---------------------+------------------+-------------------------+----------------+
| 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 | |
+---------------------+------------------+-------------------------+----------------+
|
|
|
|
|
|
|
