mysql 查询

时间：2020-08-04 19:18:36 收藏：0 阅读：98

mysql表结构相关查询

表的大小

	select TABLE_name,concat(truncate(sum(data_length)/1024/1024,2),‘MB‘) as data_size,
     concat(truncate(sum(max_data_length)/1024/1024,2),‘MB‘) as max_data_size,
     concat(truncate(sum(data_free)/1024/1024,2),‘MB‘) as data_free,
     concat(truncate(sum(index_length)/1024/1024,2),‘MB‘) as index_size
     from information_schema.tables where TABLE_SCHEMA = ‘database_name‘ GROUP BY table_name ;

原文：https://www.cnblogs.com/llkhb/p/13435016.html