mysql怎么查询最新的数据库

SELECT SCHEMA_NAME, CREATE_TIME
FROM information_schema.SCHEMATA
ORDER BY CREATE_TIME DESC
LIMIT 1;

import pymysql

# 连接到MySQL服务器
conn = pymysql.connect(host='localhost', user='your_username', password='your_password')

try:
    with conn.cursor() as cursor:
        # 获取所有数据库
        cursor.execute("SHOW DATABASES")
        databases = cursor.fetchall()
        
        latest_db = None
        latest_time = None
        
        for db in databases:
            db_name = db[0]
            cursor.execute(f"SELECT CREATE_TIME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = '{db_name}'")
            create_time = cursor.fetchone()[0]
            
            if latest_time is None or create_time > latest_time:
                latest_time = create_time
                latest_db = db_name
        
        print(f"The latest database is: {latest_db} created at {latest_time}")
finally:
    conn.close()