MYSQL的所有資料型態

請問mysql的資料型態共有哪幾種呢?!

那各代表什麼意思?!

比如說有:

VARCHAR

CHAR

INT

我知道上面兩個是字串型態

不過有些都不知道差在哪裡?!

下面INT是數值型態

請問MYSQL全部的資料型態是哪些呢?!

有附註型態的嗎?!

日期型態有分有TIME和就日期的嗎?!

麻煩各位大大了~~謝謝!!!!

Update:

謝謝~~

附註型態就是有點像註解的型態

像現在我補充的話就可以打很多字

可以換行

還蠻難解釋的

就類似[註解]的樣子

1 Answer

Rating
  • Favorite Answer

    1. Mysql Data Type 列表

    TEXT TYPES

    ======

    CHAR( ) A fixed section from 0 to 255 characters long.

    VARCHAR( ) A variable section from 0 to 255 characters long.

    TINYTEXT A string with a maximum length of 255 characters.

    TEXT A string with a maximum length of 65535 characters.

    BLOB A string with a maximum length of 65535 characters.

    MEDIUMTEXT A string with a maximum length of 16777215 characters.

    MEDIUMBLOB A string with a maximum length of 16777215 characters.

    LONGTEXT A string with a maximum length of 4294967295 characters.

    LONGBLOB A string with a maximum length of 4294967295 characters.

    NUMBER TYPES

    ======

    TINYINT( ) -128 to 127 normal

    0 to 255 UNSIGNED.

    SMALLINT( ) -32768 to 32767 normal

    0 to 65535 UNSIGNED.

    MEDIUMINT( ) -8388608 to 8388607 normal

    0 to 16777215 UNSIGNED.

    INT( ) -2147483648 to 2147483647 normal

    0 to 4294967295 UNSIGNED.

    BIGINT( ) -9223372036854775808 to 9223372036854775807 normal

    0 to 18446744073709551615 UNSIGNED.

    FLOAT A small number with a floating decimal point.

    DOUBLE( , ) A large number with a floating decimal point.

    DECIMAL( , ) A DOUBLE stored as a string , allowing for a fixed decimal point.

    DATE TYPES

    ======

    DATE YYYY-MM-DD.

    DATETIME YYYY-MM-DD HH:MM:SS.

    TIMESTAMP YYYYMMDDHHMMSS.

    TIME HH:MM:SS.

    MISC TYPES

    ======

    ENUM ( ) Short for ENUMERATION which means that each column may have one of a specified possible values.

    SET Similar to ENUM except each column may have more than one of the specified possible values.

    2. char 儲存空間長度固定 varchar 儲存空間變動,隨資料而增加

    3.何謂你說的附註型態?

    4. 日期DATE 時間 TIME

Still have questions? Get your answers by asking now.