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';
sql导出
点赞
收藏
sql导出
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';