mysql 查询数据库、表相关信息

/*查询所有的表的信息*/
select table_name 表明, engine, table_comment 描述, create_time 创建时间 from information_schema.tables 
            where table_schema = (select database()) ;

/*查询某个表的信息*/
select table_name tableName, engine, table_comment tableComment, create_time createTime from information_schema.tables 
            where table_schema = (select database()) and table_name = '表名';

/*查询某个表的所有字段*/
select column_name columnName, data_type dataType, column_comment columnComment, column_key columnKey, extra from information_schema.columns
            where table_name = '表名' and table_schema = (select database()) order by ordinal_position;