Mysql导出数据字典及主外键关系

Mysql导出数据字典

SELECT
    t.TABLE_SCHEMA AS 库名,
    t.TABLE_NAME AS 表名,
    t.COLUMN_NAME AS 字段名,
    t.COLUMN_TYPE AS 数据类型,
    t.EXTRA AS 'PK',
    CASE IFNULL(t.COLUMN_DEFAULT