##查看所有表信息

SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'pcms-zgh20190327'

##查看各个表数据量

SELECT table_name,table_rows FROM information_schema.tables

WHERE TABLE_SCHEMA = 'pcms-zgh20190327' ORDER BY table_rows DESC;