ELECT    COLUMN_NAME 字段名称,    COLUMN_TYPE 数据类型,IF    ( IS_NULLABLE = 'NO', '是', '否' ) AS '必填',    COLUMN_COMMENT 正文 FROM    INFORMATION_SCHEMA.COLUMNS WHERE    table_schema = 'srms'     AND table_name = 'base_user_role';