sqlite3.OperationalError: near ",": syntax error python

Question

I know this is a repeated question and I've looked at all of them however I cant see what I'm doing wrong.

this is my sqlite3 code:

cursor.execute('''DELETE FROM dates WHERE (Date, Start, End) VALUES( ? , ? , ? );''',
               (fulldaterem, starttimehour2, endtimehour2))

and get the error:

sqlite3.OperationalError: near ",": syntax error

where am I going wrong?

Martijn Pieters · Accepted Answer · 2017-03-08 10:09:19Z

3

A DELETE statement doesn't take any VALUES section. See the DELETE documentation:

You need to build a boolean expression for your WHERE clause:

cursor.execute(
    '''DELETE FROM dates
       WHERE Date=? AND Start=? AND End=?''',
    (fulldaterem, starttimehour2, endtimehour2))

answered Mar 8, 2017 at 10:09

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

1 Answer 1