MySQL通过information_schema获取表列字段及备注信息（表结构）

SELECT
    COLUMN_NAME AS '字段名',
    COLUMN_TYPE AS '数据类型',
    IS_NULLABLE AS '是否允许为空',
    COLUMN_KEY AS '键类型',
    COLUMN_DEFAULT AS '默认值',
    COLUMN_COMMENT AS '注释'
FROM
    information_schema.COLUMNS
WHERE TABLE_SCHEMA = '数据库名' AND TABLE_NAME = '表名'
ORDER BY ORDINAL_POSITION ASC