Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Bash
Posted by: bejoy balan
Added: Apr 22, 2020 5:23 AM
Views: 6
  1. SELECT TABLE_SCHEMA AS `Database`,TABLE_NAME AS `Table`,ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)` FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'DB NAME' ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC LIMIT 20;