[ALIGN=center][TABLE][TR][TD][ALIGN=left]名称[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]长度[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]用法[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]SMALLINT(M) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]2 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]如果为无符号数,可以存储从[FACE=Times New Roman]0[/FACE]到[FACE=Times New Roman]65535[/FACE]的数[FACE=Times New Roman]; [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left]否则可以存储从[FACE=Times New Roman]-32768[/FACE]到[FACE=Times New Roman]32767[/FACE]的数。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]MEDIUMINT(M) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]3 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]如果为无符号数,可以存储从[FACE=Times New Roman]0[/FACE]到[FACE=Times New Roman]16777215[/FACE]的数[FACE=Times New Roman];[/FACE]否则可以存储从[FACE=Times New Roman]-8388608[/FACE]到[FACE=Times New Roman]8388607[/FACE]的数[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]INT(M) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman]INTEGER(M) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]4 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]如果为无符号数,可以存储从[FACE=Times New Roman]0[/FACE]到[FACE=Times New Roman]4294967295[/FACE]的数,否则可以存储从[FACE=Times New Roman]-2147483648[/FACE]到[FACE=Times New Roman]2147483647[/FACE]的数。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]BIGINT(M) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]8 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]如果为无符号数,可以存储从[FACE=Times New Roman]0[/FACE]到[FACE=Times New Roman]18446744073709551615[/FACE]的数,否则可以存储从[FACE=Times New Roman]-9223372036854775808[/FACE]到[FACE=Times New Roman]9223372036854775807[/FACE]的数。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]FLOAT(M,D) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]4 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]单精度浮点数。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]DOUBLE(M,D) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]8 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]双精度浮点。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]DATE [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]3 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]以[FACE=Times New Roman]YYYY-MM-DD[/FACE]的格式显示。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]DATETIME [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman]HH:MM:SS [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]8 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]以[FACE=Times New Roman]YYYY-MM-DD[/FACE]的格式显示。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]TIME [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]3 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]以[FACE=Times New Roman]HH:MM:SS[/FACE]的格式显示。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]YEAR [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]1 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]以[FACE=Times New Roman]YYYY[/FACE]的格式显示。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]VARCHAR(M) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]最大[FACE=Times New Roman]M [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]变长字符串。[FACE=Times New Roman]M<=255. [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]TINYBLOB, [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman]TINYTEXT [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]最大[FACE=Times New Roman]255 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]TINYBLOB[/FACE]为大小写敏感,而[FACE=Times New Roman]TINYTEXT[/FACE]不是大小写敏感的。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]BLOB, [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman]TEXT [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]最大[FACE=Times New Roman]64K [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]BLOB[/FACE]为大小敏感的,而[FACE=Times New Roman]TEXT[/FACE]不是大小写敏感的。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]MEDIUMBLOB, [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman]MEDIUMTEXT [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]最大[FACE=Times New Roman]16M [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]MEDIUMBLOB[/FACE]为大小写敏感的,而[FACE=Times New Roman]MEDIUMTEXT[/FACE]不是大小敏感的。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]LONGBLOB, [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman]LONGTEXT [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]最大[FACE=Times New Roman]4G [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]LONGBLOB[/FACE]为大小敏感的,而[FACE=Times New Roman]LONGTEXT[/FACE]不是大小敏感的。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]ENUM(VALUE1,….) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left][FACE=Times New Roman]1[/FACE]或[FACE=Times New Roman]2 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]最大可达[FACE=Times New Roman]65535[/FACE]个不同的值。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][TR][TD][ALIGN=left][FACE=Times New Roman]SET(VALUE1,….) [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]可达[FACE=Times New Roman]8 [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][TD][ALIGN=left]最大可达[FACE=Times New Roman]64[/FACE]个不同的值。[FACE=Times New Roman] [/FACE][/ALIGN][ALIGN=left][FACE=Times New Roman][/FACE][/ALIGN][/TD][/TR][/TABLE][/ALIGN]
CREATE TABLE student
(
Name varchar(20) NOT NULL,
Chinese TINYINT(3),
Maths TINYINT(3),
English TINYINT(3),
Birthday DATE
)