select
count(TABLE_NAME),
concat(truncate(data_length/1024/1024,2),' MB') as data_size,
concat(truncate(index_length/1024/1024,2),' MB') as index_size
from information_schema.tables where TABLE_SCHEMA = 'TestDB'
原创文章，作者：3628473679，如若转载，请注明出处：https://blog.ytso.com/tech/database/267226.html