导出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