select TABLE_NAME,ENGINE,create_time,update_time,TABLE_COMMENT from TABLES where TABLE_SCHEMA=’mytable’

select * from TABLES where TABLE_SCHEMA=’my_db’ and TABLE_NAME=’test1′

字段查询语句

SELECTCOLUMN_NAME 代码,COLUMN_COMMENT 名称,COLUMN_TYPE 数据类型,’false’ as 是键,COLUMN_COMMENT 注释 FROM INFORMATION_SCHEMA.COLUMNS where table_schema =’库名’ AND table_name = ‘表名’