mysql 满查询管理平台

EXPLAIN SELECT * FROM users WHERE age > 30;

import mysql.connector
from mysql.connector import pooling

dbconfig = {
    "host": "localhost",
    "user": "user",
    "password": "password",
    "database": "mydatabase"
}

connection_pool = mysql.connector.pooling.MySQLConnectionPool(pool_name="mypool", pool_size=5, **dbconfig)

try:
    conn = connection_pool.get_connection()
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM users")
    result = cursor.fetchall()
    print(result)
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    cursor.close()
    conn.close()

from sqlalchemy import create_engine, text

engine = create_engine('mysql+mysqlconnector://user:password@localhost/mydatabase')

with engine.connect() as conn:
    result = conn.execute(text("SELECT * FROM users WHERE id = :id"), id=1)
    print(result.fetchall())