Data Types

MemSQL supports the following data types:

Integer Numbers

BOOL, BOOLEAN
BIT
TINYINT
SMALLINT
INT, INTEGER
MEDIUMINT
BIGINT

Real Numbers

DOUBLE, FLOAT, REAL
DEC, FIXED, DECIMAL
NUMERIC
NEWDECIMAL

Time and Date

DATE
TIME
TIMESTAMP
DATETIME
YEAR

String Types

CHAR(LENGTH)
CHAR
VARCHAR(LENGTH)
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT

BINARY(LENGTH)
BINARY
VARBINARY(LENGTH)
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB

ENUM
SET

Note

Values of type CHAR require 3 x LENGTH bytes of memory, as MemSQL only supports the utf8 charset (for more information see String Encoding and Collations). Values of type BINARY require LENGTH bytes of memory.

::...
免责声明:
当前网页内容, 由 大妈 ZoomQuiet 使用工具: ScrapBook :: Firefox Extension 人工从互联网中收集并分享;
内容版权归原作者所有;
本人对内容的有效性/合法性不承担任何强制性责任.
若有不妥, 欢迎评注提醒:

或是邮件反馈可也:
askdama[AT]googlegroups.com



自怼圈/年番新

DU21.7
关于 ~ DebugUself with DAMA ;-)


关注公众号, 持续获得相关各种嗯哼:
zoomquiet


粤ICP备18025058号-1
公安备案号: 44049002000656 ...::