1、获取表相关信息
select t.TABLE_NAME,t.CREATE_TIME,t.TABLE_ROWS,t.TABLE_SCHEMA
from information_schema.TABLES t
where t.TABLE_SCHEMA='test';
2、获取所有字段信息
select t.TABLE_NAME,t.COLUMN_NAME,t.COLUMN_TYPE from information_schema.COLUMNS t
where t.table_schema = 'test'
-- and table_name = 'your_table_name'