1、获取数据库test中的表名
select table_name from information_schema.tables where table_schema='test' and table_type='base table';
2、获取数据库test中表miscinfo的表结构:name, type, keyselect column_name,COLUMN_TYPE,COLUMN_KEY from information_schema.columns where table_schema='test' and table_name='miscinfo'