Sql

Search

find largest table in mysql database

SELECT table_schema as "Database", table_name AS "Table", 
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" 
FROM information_schema.TABLES 
WHERE (data_length + index_length) > 1000000 
ORDER BY table_schema, (data_length + index_length) DESC

Comment

PREVIOUS	NEXT

Code Example
Sql :: Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. Input Format The STATION table is described as follows:
Sql :: how to check port number for postgresql
Sql :: how to remove tables from postgresql
Sql :: start mysql server linux terminal
Sql :: alter user password postgres
Sql :: remove accented characters from string sql
Sql :: string to date postgres
Sql :: sql server kill all connections
Sql :: sql delete multiple ids
Sql :: oracle get table column names
Sql :: run postgres with docker
Sql :: oracle search stored procedures for text
Sql :: how remove column in mysql
Sql :: psql get sequences
Sql :: alter table engine mysql
Sql :: list mysql users
Sql :: oracle stop job
Sql :: ubuntu stop mysql from starting on boot
Sql :: convert int to string in sql server
Sql :: Create a keyspace cassandra
Sql :: how to backup mysql database linux
Sql :: mysql select greater than yesterday
Sql :: SELECT User,Host FROM mysql.user;
Sql :: alert table name mysql
Sql :: check mysql timezone
Sql :: sql command to find foreign key references
Sql :: dirinfo.name my snippets in stored procedure
Sql :: sql syntax find few columns
Sql :: apex select list ORA-20999
Sql :: delete all entries postgres

Search

SQL

find largest table in mysql database

ADD CONTENT