Mysql 表结构查询

最新推荐文章于 2024-04-20 19:59:18 发布

慢慢来_

最新推荐文章于 2024-04-20 19:59:18 发布

阅读量362

点赞数 6

分类专栏：数据库文章标签： mysql 数据库

本文链接：https://blog.csdn.net/qq_26818839/article/details/135578044

版权

数据库专栏收录该内容

11 篇文章 0 订阅

订阅专栏

查询表结构

SELECT
    TABLE_SCHEMA AS '库名',
    TABLE_NAME AS '表名',
    COLUMN_NAME AS '列名',
    ORDINAL_POSITION AS '列的排列顺序',
    COLUMN_DEFAULT AS '默认值',
    IS_NULLABLE AS '是否为空',
    DATA_TYPE AS '数据类型',
    CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',
    NUMERIC_PRECISION AS '数值精度(最大位数)',
    NUMERIC_SCALE AS '小数精度',
    COLUMN_TYPE AS '列类型',
    COLUMN_KEY 'KEY',
    EXTRA AS '额外说明',
    COLUMN_COMMENT AS '注释'
FROM
    information_schema.`COLUMNS`
WHERE
    TABLE_SCHEMA = '表名'
ORDER BY
    TABLE_NAME,
    ORDINAL_POSITION;

后续有新的相关sql，再进行补充