1. SELECT
    2. COLUMN_NAME 字段名,
    3. COLUMN_TYPE 字段类型,
    4. COLUMN_COMMENT 字段描述,
    5. '' as 是否主键,
    6. '' as 允许为空,
    7. '' as 备注
    8. FROM
    9. INFORMATION_SCHEMA.COLUMNS
    10. where
    11. TABLE_NAME ='sys_user'
    12. AND
    13. TABLE_SCHEMA = 'ry'