mysql查询所有表行数

SELECT 
  table_name,
  table_rows 
FROM
  INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = 'DATABASE_NAME' ;

 

转载于:https://www.cnblogs.com/lurenjiashuo/p/mysql-all-table-rows-count.html