17 Kas 2009 12:31 tarihinde Ugur ARPACI tarafından yayınlandı
[
16 Nis 2011 12:34 tarihinde Uğur ARPACI tarafından güncellendi
]
CHAR (length)
| Fixed-length character string
| | VARCHAR(length) | Variable length character string. Limit of the length is 1-255
| | TEXT | Variable length character string with the maximum length of 64 KB text.
| | INT(length) | Integer variable. Number that can be displayed is controlled by length.
| INT (length) UNSIGNED
| Positive intergers that stores double time more that INT. length has same function.
| DECIMAL(length,dec)
| Stores decimal numbers. length is the number of digits that can be displayed including decimals, dec is the maximum decimal number that is allowed.
Ex: 553.23 has 6 lengths and 2 dec.
| | DATE | Date value, format as YYYY-MM-DD as year month day.
| | TIME | Stores time by Hour:Munite:Second. HH:MM:SS
| | DATETIME | Datee and time are stored together. Displayed as YYYY-MM-DD HH:MM:SS
|
|
|