Mysql根据库名获取所有的表和表字段的基本信息

select
    b.table_schema as '库名',
    a.table_name as '表名',
    a.table_comment as '表注释',
    b.column_name as '列名',
    b.column_comment as '列注释',
    b.ordinal_position as '列的排列顺序',
    b.column_default as '默认值',
    b.is_nullable as '是否为空',
    b.data_type as '数据类型',
    b.character_maximum_length as '字符最大长度',
    b.numeric_precision as '数值精度(最大位数)',
    b.numeric_scale as '小数精度',
    b.column_type as '列类型',
    b.column_key '主键',
    b.extra as '额外说明'
from
    information_schema.`tables` a
    left join information_schema.`columns` b on a.table_name = b.table_name 
                                                and a.table_schema = b.table_schema
where
    a.table_schema = 'xxxxxx'