1、show tables;2、SELECT TABLE_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='dbname';–dbname为mysql的数据库名称
