统计mysql表的条数

SELECT TABLE_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{your_db}';

转载于:https://blog.51cto.com/chcearth/1350110