查询数据库表结构
select table_schema AS '数据库名',TABLE_NAME AS '数据表名',CREATE_TIME as '创建时间',TABLE_COMMENT as '描述'
from information_schema.tables where table_schema='数据库名'
查询表中列信息
select TABLE_SCHEMA AS '数据库名',TABLE_NAME as '数据库表',COLUMN_NAME as '列明',
IS_NULLABLE as '可为空',DATA_TYPE as '数据类型',CHARACTER_SET_NAME as '编码格式',
COLUMN_TYPE as '数据类型详情',COLUMN_KEY as '主键',COLUMN_COMMENT as '列描述'
from information_schema.columns where table_schema = '库名' and table_name = '表名' ;