首页 / MYSQL / mysql字段类型总结---字段类型总表_MySQL

mysql字段类型总结---字段类型总表_MySQL

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql字段类型总结---字段类型总表_MySQL，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3194字，纯文字阅读大概需要5分钟。

内容图文

原网址：http://kimbriggs.com/computers/computer-notes/mysql-notes/mysql-data-types-50.file


Type {storage}NameRangeAttributesDefault
Numeric
{1 byte}		TINYINT[(M)]-128 TO 127
[0 to 255 if UNSIGNED]		AUTO_INCREMENT
UNSIGNED, ZEROFILL,
SERIAL DEFAULT VALUE		NULL
[0 if NOT NULL]
Numeric
{2 bytes}		SMALLINT[(M)]-32,768 to 32,767
[0 to 65,535]		AUTO_INCREMENT,
UNSIGNED, ZEROFILL,
SERIAL DEFAULT VALUE		NULL
[0 if NOT NULL]
Numeric
{3 bytes}		MEDIUMINT[(M)]-8,388,608 to 8,388,607
[0 to 16,777,215]		AUTO_INCREMENT,
UNSIGNED, ZEROFILL,
SERIAL DEFAULT VALUE		NULL
[0 if NOT NULL]
Numeric
{4 bytes}		INT[(M)]-/+2.147E+9
[0 to 4.294E+9]		AUTO_INCREMENT,
UNSIGNED, ZEROFILL,
SERIAL DEFAULT VALUE		NULL
[0 if NOT NULL]
Numeric
{8 bytes}		BIGINT[(M)]-/+9.223E+18
[0 to 18.45E+18]		AUTO_INCREMENT,
UNSIGNED, ZEROFILL,
SERIAL DEFAULT VALUE		NULL
[0 if NOT NULL]
Numeric
{4 or 8}		FLOAT(p)p=0-24 --> "FLOAT"
p=25-53 --> "DOUBLE"		UNSIGNED, ZEROFILLNULL
[0 if NOT NULL]
Numeric
{4 bytes}		FLOAT[(M,D)]Min=+/-1.175E-38
Max=+/-3.403E+38		UNSIGNED, ZEROFILLNULL
[0 if NOT NULL]
Numeric
{8 bytes}		DOUBLE[(M,D)]Min=+/-2.225E-308
Max=+/-1.798E+308		UNSIGNED, ZEROFILLNULL
[0 if NOT NULL]
Numeric
{M+2}		DECIMAL[(M,[D])]
Stored as string		Max Range = DOUBLE range
Fixed point vs. DOUBLE float		UNSIGNED, ZEROFILLNULL
[0 if NOT NULL]
Bit
{8 bytes}		BIT[(M)]Binary. Display by [add zero or converting with BIN()]. M=1-64Prior to 5.03
TINYINT(1) Synonym		NULL
[0 if NOT NULL]
String
{M char's}		CHAR[(M)]M=0-255 Characters, FIXED.
Right padded with spaces.		BINARY, CHARACTER SETNULL
["" if NOT NULL]
String
{M char's1}		VARCHAR(M)M=0-65,535 Characters
M=0-255 <v5.0.3		BINARY, CHARACTER SETNULL
["" if NOT NULL]
String
{#char's1}		TINYTEXT20-255 CharactersBINARY, CHARACTER SETNULL
["" if NOT NULL]
String
{#char's1}		TEXT20-65,535 Char'sBINARY, CHARACTER SETNULL
["" if NOT NULL]
String
{#char's1}		MEDIUMTEXT20-16,777,215 Char'sBINARY, CHARACTER SETNULL
["" if NOT NULL]
String
{#char's1}		LONGTEXT20-4,294,967,295 Char'sBINARY, CHARACTER SETNULL
["" if NOT NULL]
String
{M bytes}		BINARY[(M)]M=0-255 bytes, FIXED.Global Only
(case sensitive)		NULL
["" if NOT NULL]
String
{M bytes}		VARBINARY(M)0-65,535 bytes
M=0-255 <v5.0.3		Global Only
(case sensitive)		NULL
["" if NOT NULL]
String
{#bytes1}		TINYBLOB0-255 bytesGlobal Only
(case sensitive)		NULL
["" if NOT NULL]
String
{#bytes1}		BLOB0-65,535 bytesGlobal Only
(case sensitive)		NULL
["" if NOT NULL]
String
{#bytes1}		MEDIUMBLOB0-16,777,215 bytesGlobal Only
(case sensitive)		NULL
["" if NOT NULL]
String
{#bytes1}		LONGBLOB0-4,294,967,295 bytesGlobal Only
(case sensitive)		NULL
["" if NOT NULL]
String
{1-2 bytes}		ENUM2
("A1","A2",...)		Column is exactly 1 of 1-65,535 valuesCHARACTER SETNULL [1st value if NOT NULL]
String
{1-8 bytes}		SET2
("A1","A2",...)		Column is 0 or more values in list of 1-64 membersCHARACTER SETNULL
["" if NOT NULL]
Date & Time
{3 bytes}		DATE"1000-01-01" - "9999-12-31"Global Only
(YYYY-MM-DD)		NULL
["0000-00-00" if NOT NULL]
Date & Time
{8 bytes}		DATETIME"1000-01-01 00:00:00" -
"9999-12-31 23:59:59"		Global Only
(YYYY-MM-DD hh:mm:ss)		NULL ["0000-00-00 00:00:00"
if NOT NULL]
Date & Time
{3 bytes}		TIME"-838:59:59" - "838:59:59"Global Only
(hh:mm:ss)		NULL
["00:00:00" if NOT NULL]
Date & Time
{4 bytes}		TIMESTAMP19700101000000 -
2037+		Global Only
(YYYYMMDDhhmmss)		Current Date & Time
Date & Time
{1 bytes}		YEAR1900 - 2155Global Only
(YYYY)		NULL
["0000" if NOT NULL]

Notes:

内容总结

以上是互联网集市为您收集整理的mysql字段类型总结---字段类型总表_MySQL全部内容，希望文章能够帮你解决mysql字段类型总结---字段类型总表_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/578402.html

来源：【匿名】