df to sql pandas sql achemy
snippet in sql

pandas to sql index

user7335

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

df to sql pandas sql achemy

user2537

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