use information_schema;
select table_name,table_rows from tables
where TABLE_SCHEMA = 'erpdb'
order by table_rows desc;
use information_schema;
select table_name,table_rows from tables
where TABLE_SCHEMA = 'erpdb'
order by table_rows desc;
本文标题:查看所有表的行数
本文链接:https://www.haomeiwen.com/subject/hmcswqtx.html
网友评论