Languages/MySQL?

データ型

ビット型

#sh(){{
BIT[(length)]
}}

整数型

#sh(){{
TINYINT[(length)] [UNSIGNED] [ZEROFILL]
SMALLINT[(length)] [UNSIGNED] [ZEROFILL]
MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]
INT[(length)] [UNSIGNED] [ZEROFILL]
INTEGER[(length)] [UNSIGNED] [ZEROFILL]
BIGINT[(length)] [UNSIGNED] [ZEROFILL]
}}

少数型

#sh(){{
REAL[(length,decimals)] [UNSIGNED] [ZEROFILL]
DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL]
FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]
}}

日付型

#sh(){{
DATE
TIME
TIMESTAMP
DATETIME
YEAR
}}

文字列型

#sh(){{
CHAR(length) [CHARACTER SET charset_name] [COLLATE collation_name]
VARCHAR(length) [CHARACTER SET charset_name] [COLLATE collation_name]
}}

バイナリ列型

#sh(){{
BINARY(length)
VARBINARY(length)
}}

論理型

#sh(){{
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB
}}

テキスト型

#sh(){{
TINYTEXT [BINARY] [CHARACTER SET charset_name] [COLLATE collation_name]
TEXT [BINARY] [CHARACTER SET charset_name] [COLLATE collation_name]
MEDIUMTEXT [BINARY] [CHARACTER SET charset_name] [COLLATE collation_name]
LONGTEXT [BINARY] [CHARACTER SET charset_name] [COLLATE collation_name]
}}

列挙型

#sh(){{
ENUM(value1,value2,value3,...) [CHARACTER SET charset_name] [COLLATE collation_name]
SET(value1,value2,value3,...) [CHARACTER SET charset_name] [COLLATE collation_name]
spatial_type
}}


トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2012-10-29 (月) 13:29:15