SQLite commit() use

Question

do I have to place variable_with_cursos.commit() EACH time I make an execute() method? thus:

import sqlite3
suka.execute("DROP TABLE blyadi")
blyad.commit()
blyad = sqlite3.connect('eb.db')
suka = blyad.cursor()
suka.execute("""CREATE TABLE blyadi (
condoms text,
fuck integer,
padla text)
""")

without the commit() I got the syntax error. but below an execute() runs well without a commit()

suka.execute("SELECT * FROM blyadi")
print(suka.fetchall())

Thus, where should one apply the commit()? thank you.

question from:https://stackoverflow.com/questions/65598331/sqlite-commit-use

Answer 1

Waitting for answers