select table_name tableName,
engine,
table_comment tableComment,
table_collation tableCollation,
create_time createTime
from information_schema.tables
where table_schema = (select database())
order by create_time desc;
select column_name columnName,
data_type dataType,
column_comment columnComment,
column_key columnKey,
extra ,
is_nullable as isNullable,
column_type as columnType
from information_schema.columns
where table_name = 'pro_template'
and table_schema = (select database())
order by ordinal_position;
标签:comment,name,column,查询,mysql,table,schema,select,结构
From: https://www.cnblogs.com/alvisClub/p/17211563.html