mysql help create_MySQL 列，可选择的数据类型（通过sql命令查看：`help create table;`）...

MySQL 列，可选择的数据类型(通过sql命令查看：help create table;)

BIT[(length)]

| TINYINT[(length)] [UNSIGNED] [ZEROFILL]

| SMALLINT[(length)] [UNSIGNED] [ZEROFILL]

| MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL]

| INT[(length)] [UNSIGNED] [ZEROFILL]

| INTEGER[(length)] [UNSIGNED] [ZEROFILL]

| BIGINT[(length)] [UNSIGNED] [ZEROFILL]

| 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]

| DATE

| TIME[(fsp)]

| TIMESTAMP[(fsp)]

| DATETIME[(fsp)]

| YEAR

| CHAR[(length)]

[CHARACTER SET charset_name] [COLLATE collation_name]

| VARCHAR(length)

[CHARACTER SET charset_name] [COLLATE collation_name]

| BINARY[(length)]

| VARBINARY(length)

| TINYBLOB

| BLOB[(length)]

| MEDIUMBLOB

| LONGBLOB

| TINYTEXT

[CHARACTER SET charset_name] [COLLATE collation_name]

| TEXT[(length)]

[CHARACTER SET charset_name] [COLLATE collation_name]

| MEDIUMTEXT

[CHARACTER SET charset_name] [COLLATE collation_name]

| LONGTEXT

[CHARACTER SET charset_name] [COLLATE collation_name]

| ENUM(value1,value2,value3,...)

[CHARACTER SET charset_name] [COLLATE collation_name]

| SET(value1,value2,value3,...)

[CHARACTER SET charset_name] [COLLATE collation_name]

| JSON

| spatial_type

原文：https://www.cnblogs.com/cag2050/p/10382957.html