1、查看Mysql 数据库 "mysql"下所有表的表名、表注释及其数据量
- TABLE_NAME:表名
- TABLE_COMMENT:表注释
SELECT TABLE_NAME,TABLE_COMMENT,TABLE_ROWS FROM information_schema.tables WHERE TABLE_SCHEMA = 'mysql' ORDER BY TABLE_NAME;
2、查询数据库 ‘mysql’ 下表 ‘student’ 所有字段注释
- COLUMN_NAME:字段编码
- COLUMN_COMMENT:字段注释
- COLUMN_DEFAULT:默认值
- IS_NULLABLE:是否为空
- DATA_TYPE:字段类型(如:varchar)
- COLUMN_KEY:主键
- COLUMN_TYPE:字段类型及长度(如 varchar(50))
SELECT COLUMN_NAME,COLUMN_COMMENT,COLUMN_DEFAULT,IS_NULLABLE,DATA_TYPE,COLUMN_KEY,COLUMN_TYPEFROM INFORMATION_SCHEMA.Columns WHERE table_name='student' AND table_schema='mysql'
标签:COMMENT,NAME,COLUMN,数据库,注释,字段,mysql,TABLE From: https://www.cnblogs.com/yangjcBlog/p/17584586.html