z123561的博客

MySQL 借助INFORMATION_SCHEMA.TABLES 精确 统计 表记录数 SELECT CONCAT( 'SELECT "', table_name, '" AS table_name, COUNT(*) AS exact_row_count FROM `', table_schema, '`.`', table_name, '` UNION ' ) FROM INFORMATION_SCHEMA.TABLES W...