Home  Data Types in MySQL
Strings
| Data type | Description |
| CHAR (size) |
Strings фиксированной длиной (могут содержать буквы, цифры и специальные символы). Фиксированный размер указан в скобках. Можно записать до 255 символов |
| VARCHAR (size) |
It can store up to 255 characters. |
| TINYTEXT |
It can store up to 255 characters. |
| TEXT |
It can store up to 65,535 characters. |
| BLOB |
It can store up to 65,535 characters. |
| MEDIUMTEXT |
|
| MEDIUMBLOB |
|
| LONGTEXT |
|
| LONGBLOB |
|
| ENUM (x, y, z, etc.) |
|
| SET |
|
Fractional numbers
| Data type | Description |
| TINYINT (size) |
Can store numbers from -128 to 127 |
| SMALLINT (size) |
Range from -32 768 to 32 767 |
| MEDIUMINT (size) |
The range is -8388608 to 8388607 |
| INT (size) |
Range from -2,147,483,648 to 2,147,483,647 |
| BIGINT (size) |
|
| FLOAT (size, d) |
|
| DOUBLE (size, d) |
|
| DECIMAL (size, d) |
|
Date and Time
| Data type | Description |
|
Date in YYYY-MM-DD |
| DATETIME () |
Date and Time в формате ГГГГ-ММ-ДД ЧЧ:ММ:СС |
| TIMESTAMP () |
Date and Time в формате timestamp. Однако при получении значения поля оно отображается не в формате timestamp, а в виде ГГГГ-ММ-ДД ЧЧ:ММ:СС |
| TIME () |
Time in HH: MM: SS |
| YEAR () |
|
|
Nice Ajax Poll
Which one of my extensions is the best?
|
Comments
I would not say ...
ENUM can have only one meaning, of those that byly defined previously, SET can have several meanings simultaneously.
If I'm wrong, correct. Quote