Python Script to Delete Data from SQLite DB [duplicate]

Question

I'm new to python and SQLite, so I apologize if this is a dumb question. I've written the code below to open up a database and delete the data in the STAGING_LIDs table. The script runs, but when I check the DB, the data is still there. Am I doing something wrong?

import sqlite3
import csv

conn = sqlite3.connect('C:\\SQLite\\Budget_Dev.db')
cur = conn.cursor()

#delete all table data
cur.execute("DELETE FROM STAGING_LIDs;")

I'm using bernie's answer in this question (the accepted answer) as a template.

CL. · Accepted Answer · 2016-08-05 14:12:57Z

2

I figured it out. I needed to add a line:

conn.commit()

edited Aug 5, 2016 at 14:12

CL.

182k18 gold badges241 silver badges282 bronze badges

answered Aug 5, 2016 at 13:06

jones-chris

7294 gold badges16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python Script to Delete Data from SQLite DB [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related