mysql 数据库字段&表名 注释查询
文章目录
SELECT
TABLE_NAME "表名",
COLUMN_NAME "字段名称",
COLUMN_TYPE "字段类型长度",
IF
( EXTRA = "auto_increment", CONCAT( COLUMN_KEY, "(", IF ( EXTRA = "auto_increment", "自增长", EXTRA ), ")" ), COLUMN_KEY ) "主外键",
IS_NULLABLE "空标识",
COLUMN_COMMENT "字段说明"
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'gzh-test-sn';
SELECT
TABLE_NAME "表名",
TABLE_COMMENT "注释"
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = 'gzh-test-sn';
评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论