Deleting from a database...

[Mort101]

Hi Guys,

I am just starting with Python and am making a small "app" for my first project.

One of the problems I am having is that when I run this it does exactly what i need it to do BUT when I shut it down and then re-run it it adds the data to the file again rather than over writing it, which makes it tricky to then use the data for the next part of my cunning plan.

I realise this is probably pretty easy but all the examples I have seen are just over my head as of yet, can anyone shed some light on this for me please?

import sqlite3, csv

conn = sqlite3.connect("LE2.db")
c = conn.cursor()

sql = """
        CREATE TABLE IF NOT EXISTS TokenTable (
            
    ad1 TEXT,
    ad2 TEXT,
    ad3 TEXT


        )"""

c.execute(sql)

with open("LE.csv", "r") as file:    
    no_records = 0
    for row in file:

        c.execute("INSERT INTO TokenTable VALUES (?,?,?)", row.split(","))
        conn.commit()
        no_records += 1

Thanks,

Mort