How to delete a record from table?

The correct syntax for a parameterized query is:

mydata = c.execute("DELETE FROM Zoznam WHERE Name=?", (data3,))

Make sure the parameter uses the comma, to make it a python tuple.

This will help prevent SQL Injection which is possible when passing in a formatted string. More on SQL Injection here

Related post here.

I'm a little late to the party but if you Google search "python sqlite delete row" This is the first thing that comes up and I was having the same issue where things were not getting DELETE'd from my sqlite DB.I'm using Python 2.7 on Debian Jessie.

Previously, when I wrote Python code for adding and retrieving information in the sqlite database, I had written the commands with correct capitalization where needed and it worked.

curs.execute("SELECT example_column1 FROM example_table WHERE example_column2=(?)", (Variable,))

However...

curs.execute("DELETE FROM example_table WHERE example_column1=(?)", (Variable,)):

This for some reason does not work with the DELETE command. I had to send that command in all lower-case before sqlite would respect the command being sent.

conn=sqlite3.connect('example.db')curs=conn.cursor()curs.execute("delete from example_table where example_column=(?)", (Variable,))conn.commit()conn.close()

I have no idea why. I tried all the previously mentioned methods but having the command sent in lowercase was the only way I could get it to work.Hope this helps any struggling neophytes in their journey into Python and sqlite.

Try with:

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

Without the ',' and the '?' between '()'