Mysql show database sorted by creation date?

Question

Is there a way to get a list of MySQL databases ordered by creation date or last update date using a command?

Answer 1

Try this , if you want by update date you can order it by update_time

SELECT 
table_schema,
MAX(create_time) create_time,
MAX(update_time) update_time
FROM information_schema.tables
Group by TABLE_SCHEMA
Order by create_time desc