MySql查询数据字典的SQL语句

马克88

于 2020-11-08 18:29:06 发布

阅读量2.5k

点赞数

分类专栏： Mysql等数据库

本文链接：https://blog.youkuaiyun.com/yyws2039725/article/details/109562700

版权

Mysql等数据库专栏收录该内容

24 篇文章

订阅专栏

Select
t.COLUMN_NAME 字段,
t.COLUMN_COMMENT 注释,
t.COLUMN_TYPE 类型,
t.COLUMN_DEFAULT 默认
FROM
information_schema.`COLUMNS` t,
information_schema.`TABLES` r
WHERE
t.TABLE_NAME LIKE 'wp_cao_coupon'
AND t.TABLE_SCHEMA = 'wp_table'
AND t.TABLE_NAME = r.TABLE_NAME;

Select
r.TABLE_COMMENT,
t.TABLE_NAME,
t.COLUMN_NAME,
t.COLUMN_COMMENT,
t.DATA_TYPE,
t.COLUMN_TYPE,
t.IS_NULLABLE,
t.COLUMN_DEFAULT,
t.COLUMN_KEY,
t.EXTRA
FROM
information_schema.`COLUMNS` t,
information_schema.`TABLES` r
WHERE
t.TABLE_NAME LIKE 'wp_%'
AND t.TABLE_SCHEMA = 'wp_table'
AND t.TABLE_NAME = r.TABLE_NAME;

Select
r.TABLE_COMMENT,
t.TABLE_NAME,
t.COLUMN_NAME,
t.COLUMN_COMMENT,
t.DATA_TYPE,
t.COLUMN_TYPE,
t.IS_NULLABLE,
t.COLUMN_DEFAULT,
t.COLUMN_KEY,
t.EXTRA
FROM
information_schema.`COLUMNS` t,
information_schema.`TABLES` r
WHERE
t.TABLE_NAME LIKE 'wp_cao_coupon'
AND t.TABLE_SCHEMA = 'wp_table'
AND t.TABLE_NAME = r.TABLE_NAME;