查询mysql的表结构数据字典

最新推荐文章于 2024-06-24 16:03:24 发布

不屑哥

最新推荐文章于 2024-06-24 16:03:24 发布

阅读量762

点赞数 1

分类专栏： mysql

本文链接：https://blog.csdn.net/fuck487/article/details/107685903

版权

mysql 专栏收录该内容

21 篇文章 2 订阅

订阅专栏

参考：https://www.cnblogs.com/yuan951/p/7338871.html

SELECT
        a.TABLE_SCHEMA AS tableSchema,
        a.TABLE_NAME AS tableName,
        a.COLUMN_NAME AS columnName,
        a.ORDINAL_POSITION AS ordinalPosition,
        a.COLUMN_DEFAULT AS columnDefault,
        a.IS_NULLABLE AS isNullable,
        a.COLUMN_TYPE AS columnType,
        a.COLUMN_COMMENT AS columnComment,
        a.COLUMN_KEY AS columnKey,
        a.EXTRA AS extra,
        b.TABLE_COMMENT AS tableComment
        FROM information_schema.COLUMNS a
        LEFT JOIN information_schema.TABLES b ON a.TABLE_NAME=b.TABLE_NAME
        WHERE a.TABLE_SCHEMA='数据库名'