##查看所有表信息
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;

 

版权声明：本文为penghq原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/penghq/p/10694197.html