/*查询所有的表的信息*/
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;