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