在使用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))
参考: