mysql查询库中所有表数据行数

1、查询库中所有表数据行数sql

SELECT 
    table_schema AS 'Database', 
    table_name AS 'Table', 
    table_rows AS 'RowCount'
FROM 
    information_schema.tables
WHERE 
    table_schema = '替换成库名' 
    AND table_type = 'BASE TABLE'; 

2、拼接清除表中有数据的sql

SELECT 
    CONCAT('truncate TABLE `', TABLE_SCHEMA, '`.`', TABLE_NAME, '`;') AS `清空表语句`
FROM 
    INFORMATION_SCHEMA.TABLES
WHERE 
    TABLE_TYPE = 'BASE TABLE'
    AND TABLE_SCHEMA NOT IN ('information_schema', 'mysql', 'performance_schema', 'sys')
    AND table_rows>0
    and table_schema = '替换成库名' 
ORDER BY 
    TABLE_SCHEMA, TABLE_NAME;