alter table添加列
ALTER TABLE table_name
ADD column_name datatype;
alter table column将数据类型更改为text mysql
ALTER TABLE tablename MODIFY columnname INTEGER;
mysql显示列数据类型
SELECT DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where
table_schema = ’yourDatabaseName’ and table_name = ’yourTableName’.
在mysql中更改数据类型
ALTER TABLE table_name
CHANGE COLUMN column_name column_name datatype;