SQL文の収集
259 ワード
---Mysql
use information_schema;
select table_name,concat(round((data_length+index_length)/1024/1024/1024),'GB') as table_capacity,table_rows from tables where table_schema='db_name' order by table_capacity desc;