mysql 전체 table 별 row count 구하기

SELECT table_name, table_rows FROM information_schema. tables WHERE table_schema = 'DBNAME' ORDER BY table_name;

https://m.blog.naver.com/PostView.nhn?blogId=jevida&logNo=221129717819&proxyReferer=https%3A%2F%2Fwww.google.com%2F