SQLite error in Python

Question

I have a simple piece of code to update a row in sqlite:

def UpdateElement(new_user,new_topic):
    querycurs.execute('''INSERT into First_Data (topic) values(?) WHERE user = (?)''',([new_topic],    [new_user]))

However, this gives me the error:

Traceback (most recent call last):
  File "C:/Python27/Database.py", line 40, in <module>
    UpdateElement("Abhishek Mitra","Particle Physics")
  File "C:/Python27/Database.py", line 36, in UpdateElement
    querycurs.execute('''INSERT into First_Data (topic) values(?) WHERE user = (?)''',([new_topic],[new_user]))
OperationalError: near "WHERE": syntax error

mechanical_meat · Accepted Answer · 2013-10-02 17:44:27Z

3

You should be using an UPDATE statement instead of INSERT:

def UpdateElement(new_user,new_topic):
    querycurs.execute('''UPDATE First_Data 
                         SET topic = ? 
                         WHERE user = ?''', (new_topic, new_user))

answered Oct 2, 2013 at 17:44

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

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

Comments

C Reese · Accepted Answer · 2013-10-02 17:45:52Z

0

The problem arises from the use of the parentheses and sending in new_user as an array, I believe. Values is an array, user is not.

You want something like:

cur.execute("UPDATE table SET value=? WHERE name=?", (myvalue, myname))

But yes, UPDATE sounds like what you wanted in the first place.

answered Oct 2, 2013 at 17:45

C Reese

789 bronze badges

Collectives™ on Stack Overflow

SQLite error in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related