SQL/MySQL/Data Type/Data Type Summary

Материал из SQL эксперт
Перейти к: навигация, поиск

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          |                | 
+---------------------+------------------+-------------------------+----------------+