MySQL useful queries

mysql-useful-queries.md

Useful SQL queries

List databases by creation date

SELECT table_schema AS Database_Name, MIN(create_time) AS Creation_Time FROM information_schema.tables WHERE table_schema like 'some_db_name%' Group by table_schema;

List databases with size

SELECT table_schema "DB Name",ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"  FROM information_schema.tables  GROUP BY table_schema;