Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to check database size

// QUERY 

SELECT table_schema AS "Database Name",
  ROUND(SUM(data_length + index_length) / 1024 / 1024, 2)
  AS "Size in (MB)"
  FROM information_schema.TABLES
  GROUP BY table_schema;
Comment

check database size

SELECT table_schema AS "Database Name",
  ROUND(SUM(data_length + index_length) / 1024 / 1024, 2)
  AS "Size in (MB)"
  FROM information_schema.TABLES
  GROUP BY table_schema;
Comment

PREVIOUS NEXT
Code Example
Sql :: closure in sql 
Sql :: oracle chain step succeeded 
Sql :: postgresql display subquery as json 
Sql :: create more than 1 tables with references to each other in sqlite3 
Sql :: mysql-split-and-join-the-values 
Sql :: TSQL select 50 records at a time 
Sql :: fonction stockée sql 
Sql :: oracle table change tablespace lob column 
Sql :: create sql database 
Sql :: mysql vs sql server performance benchmark 
Sql :: grouping by email domain mysql 
Sql :: join 
Sql :: sum over partition by postgresql 
Sql :: uninstall mysql centos 7 
Sql :: ring MySQL Create Database 
Sql :: flashback in bigquery 
Sql :: update mysql from paypal shopping cart and ipn 
Sql :: 10 random questions use python and SQL 
Sql :: partitioning in oracle-base 
Sql :: what is group function in sql 
Sql :: how to select multiple columns in sql 
Sql :: SQL sort on a calculation 
Sql :: utf8_encode mysql 
Sql :: mysql stand for 
Sql :: mysql insert into select transaction c# 
Csharp :: unity mouse lock 
Csharp :: add only bottom border to container flutter 
Csharp :: Vector3.signedangle not showin singed angle in unity 
Csharp :: c# Escape sequence 
Csharp :: movement script c# 
ADD CONTENT
Topic
Content
Source link
Name
2+2 =