I am trying to program an sql database in python that asks for your name and stores it in a database. The problem is that it stores it but then when I reload, the data is gone. Here is the code:
conn = sqlite3.connect('python.db')
c = conn.cursor()
c.execute('CREATE TABLE IF NOT EXISTS RecordONE (Number REAL, Name TEXT)')
name = input("What is your name?")
number = "1234"
c.execute("INSERT INTO RecordONE (Number, Name) VALUES(?, ?)", (number, name))
What could the problem be?