导入create_engine

from sqlalchemy import create_engine

创建数据库连接

engine = create_engine('mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8mb4'.format(user, password, host, port, database))

写sql语句

sql = f"""select , from table_name where …… """

执行sql

= engine.execute(sql).fetchone()

关闭连接

engine.dispose()