How to delete record from table?

Question

Hi,

I have a problem with deleting a record from sqlite3 database:

conn = sqlite3.connect('databaza.db')
c = conn.cursor()
data3 = str(input('Please enter name: '))
mydata = c.execute('DELETE FROM Zoznam WHERE Name=?', (data3,))
conn.commit()
c.close

All is good, but delete doesn't work! Have anybody some idea?

Answer 1

Check the file permissions.

An aside, I prefer the tokenized method:

mydata = c.execute("DELETE FROM Zoznam WHERE Name='%s'" % data3)

Answer 2

I advise you to first make a string for the query , and then execute it. ex:

query = "delete from zoznam where name = '%s' " % data3
c.execute(query)
conn.commmit() 

Answer 3

Thank you to everybody who tried to help. The right code is:

conn = sqlite3.connect('databaza.db')
c = conn.cursor()
conn.text_factory = str    
data3 = str(input('Please enter name: '))
query = "DELETE FROM Zoznam WHERE Name = '%s';" % data3.strip()
print(query)
mydata = c.execute(query)

Answer 4

mydata = c.execute('DELETE FROM Zoznam WHERE Name=%s', data3)

never use :

"DELETE FROM Zoznam WHERE Name='%s'" % data3

if you want to know why just put:

data = "a';DROP TABLE Zoznam;'"

and all your problem get solve :)

the database connector is responsible of escaping data if you pass it as i told you .