python执行非查询类sql时最好使用conn.execute

在使用read_sql_query时可能会报错：

>>> from sqlalchemy import create_engine
>>> import pandas as pd
>>> engine = create_engine('mysql+pymysql://{}:{}@{}:{}/{}'.format(user, password, address, port, databass))
>>> pd.read_sql_query("DELETE FROM {} WHERE {}".format(table, data), engine)
sqlalchemy.exc.ResourceClosedError: This result object does not return rows. It has been closed automatically.

这是由于这条sql执行完成后没有返回
因而在执行非查询类sql时最好使用如下方式：

>>> from sqlalchemy import create_engine
>>> engine = create_engine('mysql+pymysql://{}:{}@{}:{}/{}'.format(user, password, address, port, databass))
>>> with engine.begin() as conn:
        conn.execute("DELETE FROM {} WHERE {}".format(table, data))

参考：

1. https://stackoverflow.com/a/51724985/7151777
2. https://docs.sqlalchemy.org/en/13/core/connections.html