导出mysql的表结构的字段为excel

 

SELECT
TABLE_NAME,COLUMN_NAME,DATA_TYPE,COLUMN_COMMENT
FROM
INFORMATION_SCHEMA.COLUMNS
where TABLE_SCHEMA='app_peace_service_db'
order by TABLE_NAME;

 

然后复制到excel