Mysql 数据库信息查询

查询一个数据库中所有表名

SELECT TABLE_NAME FROM INFORMATION_SCHEMA. TABLES WHERE TABLE_SCHEMA = '数据库名' AND TABLE_NAME NOT IN (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.views WHERE TABLE_SCHEMA = '数据库名');

查询一个数据库中所有视图名

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.views WHERE TABLE_SCHEMA = '数据库名'

查看一个数据库中所有字段名

select * from information_schema.columns where table_schema = '数据库名' and table_name in(SELECT TABLE_NAME FROM INFORMATION_SCHEMA. TABLES WHERE TABLE_SCHEMA = '数据库名' AND TABLE_NAME NOT IN (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.views WHERE TABLE_SCHEMA = '数据库名')) ;#你要查的表

查看表中列名和注释

select column_name, column_comment from information_schema.columns where table_schema ='数据库名' and table_name = '表名' ;

查看表的注释

select table_name,table_comment from information_schema.tables where table_schema ='数据库名' and table_name = '表名' ;

查看表中字段基本信息

SHOW COLUMNS FROM '表名'