DESCRIBE database_name.table_name;
SHOW COLUMNS FROM database_name.table_name;
ALTER TABLE database_name.table_name CHANGE column_name column_name data_type;
示例代码:
--查询表的结构 DESCRIBE mydatabase.mytable;
--查询列名 SHOW COLUMNS FROM mydatabase.mytable;
--修改数据类型 ALTER TABLE mydatabase.mytable CHANGE salary salary INT;