select concat(‘select "’,table_name,’",count(1) from ‘,table_name,’ union all’)
from informaation_schema.tables
where table_schema=“work1”
;
information_schema
最新推荐文章于 2024-08-02 13:01:39 发布
select concat(‘select "’,table_name,’",count(1) from ‘,table_name,’ union all’)
from informaation_schema.tables
where table_schema=“work1”
;