mysql查看表结构

SELECT COLUMN_NAME,DATA_TYPE,COLUMN_COMMENT from information_schema.COLUMNS
where TABLE_SCHEMA='cecoal_datacenter206' and TABLE_NAME='ce_data_invest_nationinvest'
ORDER BY ORDINAL_POSITION;

 

 

cecoal_datacenter206:数据库名

表名：ce_data_invest_nationinvest