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 '表名'