import sqlite3 path = "test.sqlite" conn = sqlite3.connect(path) c = conn.cursor() c.execute("insert into post(msg) values('Salut')") c.execute("select * from post") print(c.fetchone()) conn.commit() conn.close()