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 ;

mysql 查询