×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Dmitriy Lanets
Added: Jul 22, 2015 6:40 AM
Views: 16
Tags: no tags
  1. SELECT table_schema "database_name", SUM( data_length + index_length )/1024/1024 "Database size in MB" FROM information_schema. TABLES
  2.       WHERE TABLE_SCHEMA = "ps_motors"
  3.       GROUP BY TABLE_SCHEMA;