目前只找到一張一張表導出的方式
使用information_schema傳入表名查詢
字段名根據需要自行刪減,一般保留序號、字段名、類型、說明就行
SELECT
`COLUMNS`.ORDINAL_POSITION AS '序號',
`COLUMNS`.COLUMN_NAME AS '字段名',
`COLUMNS`.COLUMN_TYPE AS '類型(長度)',
`COLUMNS`.NUMERIC_PRECISION AS '精度',
`COLUMNS`.NUMERIC_SCALE AS '小數位數',
`COLUMNS`.COLUMN_DEFAULT AS '默認值',
IF( `COLUMNS`.IS_NULLABLE = 'YES', '√', '' ) AS '允許空',
IF( `COLUMNS`.COLUMN_KEY = 'PRI', '√', '' ) AS '主鍵',
`COLUMNS`.COLUMN_COMMENT AS '說明'
FROM
information_schema.COLUMNS
WHERE table_name = 'sys_config'