mysql使用.sql_MySQL 使用sql来生成sql

备注:测试数据库版本为MySQL 8.0

一.需求

我想查询某个库下所有表的总记录数

二.解决方案

-- 通过系统表 拼接sql

select concat('select count(*) from ',table_name,';') tab_count

from information_schema.tables

where table_schema = 'ZQS';

-- 拷贝输出进行执行

select count(*) from area_admin_contrast;

select count(*) from area_admin_info;

select count(*) from audit_log;

select count(*) from bb;

select count(*) from bonus;

select count(*) from char_test;

select count(*) from dept;

select count(*) from emp;

select count(*) from new_emps;

select count(*) from new_sal;

select count(*) from salgrade;

select count(*) from shawn_tmp;

select count(*) from t;

select count(*) from t1;

select count(*) from t2;

select count(*) from t4;

select count(*) from t_ctas;

select count(*) from t_date;

select count(*) from t_like;

select count(*) from test;

select count(*) from test1;

select count(*) from test_enum_set;

select count(*) from testa;

select count(*) from tmp_zqs;

select count(*) from user_info;

select count(*) from user_info_history;

select count(*) from users;

select count(*) from v;

select count(*) from zqs1;