Day: September 29, 2020

How to check the creation date of your databases (MySQL)

The Query If you have a lot of databases and you want to check their creation dates just run this SELECT. If the ‘create_time’ is null then your user won’t have the necessary permissions. SELECT table_schema, MAX(create_time) create_time FROM information_schema.tables — where TABLE_SCHEMA =’myDb’ — uncomment for specific database GROUP BY TABLE_SCHEMA — SORT BY…