MySQL Common Data Types
来源:百度文库 编辑:神马文学网 时间:2024/07/04 22:38:52
MySQL Data Types
TYPE
SIZE
DESCRIPTION
CHAR[Length]
Length bytes
A fixed-length field from 0 to 255 characters long
VARCHAR[Length]
String length + 1 bytes
A variable-length field from 0 to 255 characters long
TINYTEXT
String length + 1 bytes
A string with a maximum length of 255 characters
TEXT
String length + 2 bytes
A string with a maximum length of 65,535 characters
MEDIUMTEXT
String length + 3 bytes
A string with a maximum length of 16,777,215 characters
LONGTEXT
String length + 4 bytes
A string with a maximum length of 4,294,967,295 characters
TINYINT[Length]
1 byte
Range of 128 to 127 or 0 to 255 unsigned
SMALLINT[Length]
2 bytes
Range of 32,768 to 32,767 or 0 to 65,535 unsigned
MEDIUMINT[Length]
3 bytes
Range of 8,388,608 to 8,388,607 or 0 to 16,777,215 unsigned
INT[Length]
4 bytes
Range of 2,147,483,648 to 2,147,483,647 or 0 to 4,294,967,295 unsigned
BIGINT[Length]
8 bytes
Range of 9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 or 0 to 18,446,744,073,709,551,615 unsigned
FLOAT
4 bytes
A small number with a floating decimal point
DOUBLE[Length, Decimals]
8 bytes
A large number with a floating decimal point
DECIMAL[Length, Decimals]
Length + 1 or Length + 2 bytes
A DOUBLE stored as a string, allowing for a fixed decimal point
DATE
3 bytes
In the format of YYYY-MM-DD
DATETIME
8 bytes
In the format of YYYY-MM-DD HH:MM:SS
TIMESTAMP
4 bytes
In the format of YYYYMMDDHHMMSS; acceptable range ends in the year 2037
TIME
3 bytes
In the format of HH:MM:SS
ENUM
1 or 2 bytes
Short for enumeration, which means that each column can have one of several possible values
SET
1, 2, 3, 4, or 8 bytes
Like ENUM except that each column can have more than one of several possible values
from site :http://blog.chinaunix.net/u2/60586/showart_472991.html
TYPE
SIZE
DESCRIPTION
CHAR[Length]
Length bytes
A fixed-length field from 0 to 255 characters long
VARCHAR[Length]
String length + 1 bytes
A variable-length field from 0 to 255 characters long
TINYTEXT
String length + 1 bytes
A string with a maximum length of 255 characters
TEXT
String length + 2 bytes
A string with a maximum length of 65,535 characters
MEDIUMTEXT
String length + 3 bytes
A string with a maximum length of 16,777,215 characters
LONGTEXT
String length + 4 bytes
A string with a maximum length of 4,294,967,295 characters
TINYINT[Length]
1 byte
Range of 128 to 127 or 0 to 255 unsigned
SMALLINT[Length]
2 bytes
Range of 32,768 to 32,767 or 0 to 65,535 unsigned
MEDIUMINT[Length]
3 bytes
Range of 8,388,608 to 8,388,607 or 0 to 16,777,215 unsigned
INT[Length]
4 bytes
Range of 2,147,483,648 to 2,147,483,647 or 0 to 4,294,967,295 unsigned
BIGINT[Length]
8 bytes
Range of 9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 or 0 to 18,446,744,073,709,551,615 unsigned
FLOAT
4 bytes
A small number with a floating decimal point
DOUBLE[Length, Decimals]
8 bytes
A large number with a floating decimal point
DECIMAL[Length, Decimals]
Length + 1 or Length + 2 bytes
A DOUBLE stored as a string, allowing for a fixed decimal point
DATE
3 bytes
In the format of YYYY-MM-DD
DATETIME
8 bytes
In the format of YYYY-MM-DD HH:MM:SS
TIMESTAMP
4 bytes
In the format of YYYYMMDDHHMMSS; acceptable range ends in the year 2037
TIME
3 bytes
In the format of HH:MM:SS
ENUM
1 or 2 bytes
Short for enumeration, which means that each column can have one of several possible values
SET
1, 2, 3, 4, or 8 bytes
Like ENUM except that each column can have more than one of several possible values
from site :http://blog.chinaunix.net/u2/60586/showart_472991.html
MySQL Common Data Types
Using Java to Handle Custom WSDL Data Types
Unemployment types
mysql
Types of Electoral Systems
Two Types of People
types of business ownship
Renesas SuperH common architecture
vfp Common Dialogs
Common Theme System Functions
Common Files文件夹是什么?
funiture common word
Available Resource Types | Android Developers
[Lucas10] 5.5. Useful Report Types
Unprotected Data
Data Recovery
Common Lisp语言快速入门
Common Interview Questions and Answers
Common Interview Questions and Answer
Keeping The Common Corridor Clear
Data Models, Data Modeling, Data Warehouse and Data Warehousing by Universal Data Models
Latin America: the two types of “left”
Unemployment types - Wikipedia, the free ency...
Use Rational Data Architect to integrate data...