MySQL之information_schema应用小技巧
select * from information_schema.schemata;
select schema_name from information_schema.schemata;
select * from information_schema.tables;
select table_schema from information_schema.tables;
select table_name from information_schema.tables;
select * from information_schema.columns;
select table_schema from information_schema.columns;
select table_name from information_schema.columns;
select column_name from information_schema.columns;