to sql pandas

1resultDf.to_sql('table_name', engine, schema="schema_name", if_exists="append", index=False)

1from sqlalchemy import create_engine
2engine = create_engine('sqlite://', echo=False)
3df.to_sql('users', con=engine)
4engine.execute("SELECT * FROM users").fetchall()
5

1>>> df.to_sql('users', con=engine)
2>>> engine.execute("SELECT * FROM users").fetchall()
3[(0, 'User 1'), (1, 'User 2'), (2, 'User 3')]
4