一.查看数据库清单
show databases;
二.查看数据库下表清单
方法1)
show full tables from ${schema名};
方法2)
use ${数据库名};
show tables;
三.查看表详细信息
select * from information_schema.tables where table_schema = ${Schema名} and table_name = ${表名};
四.查看表字段详细信息
方法1)
show full columns from ${表名};
方法2)
select * from information_schema.columns where table_schema = ${schema名} and table_name = ${表名};