- SELECT
- CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2))," MB") AS Size
- FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA like '%YOUR_DATABASE_NAME_HERE%' ;
- -- 其中YOUR_DATABASE_NAME_HERE便是你的数据库名
- --该片段来自于http://www.codesnippet.cn/detail/090120131469.html
来源: http://www.codesnippet.cn/detail/090120131469.html