mysql查看库表信息，mysql查看表结构

左手握着幸福8

已于 2023-02-03 11:02:22 修改

阅读量307

点赞数

分类专栏： MySql 文章标签： sql mysql java Powered by 金山文档

于 2023-02-03 10:55:44 首次发布

本文链接：https://blog.csdn.net/gmm313/article/details/128862553

版权

MySql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

mysql语句查看库表信息

SELECT
  TABLE_SCHEMA,TABLE_NAME,TABLE_COMMENT,TABLE_ROWS,CREATE_TIME,UPDATE_TIME,TABLE_COLLATION
FROM
  `information_schema`.`TABLES`
WHERE `TABLES`.`TABLE_SCHEMA` ='wdl_base'

-- wdl_base 库名

mysql查看表结构

SELECT TABLE_SCHEMA,TABLE_NAME,IS_NULLABLE,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,COLUMN_TYPE,COLUMN_COMMENT
FROM
  `information_schema`.`COLUMNS` where `TABLE_SCHEMA`='wdl_base' and `TABLE_NAME`='wdl_repertory' order by `ORDINAL_POSITION`;

-- wdl_base 库名
-- wdl_repertory 表名