sqlite3.OperationalError: no such column: For update command in sqlite3 python

Question

I am trying to update values in my sqlite database using the below function

def updateNameById(self, id, val):
    c.execute("UPDATE {0} SET name = {1} WHERE rowid = {2}".format(table,val,id))

I also tried to write this function in different variations like

    c.execute("UPDATE "+table+" SET name = "+val+" WHERE rowid = "+id)
    #same error

I also tried

  c.execute("UPDATE ? table SET name = ? WHERE rowid = ?,(table,val,id))
  #this one gives syntax error near ?

when called from with code

print(obj.updateNameById(1,'Aquib'))

It gives sqlite3.OperationalError: no such column: Aquib

I also tried to put the id parameter as string and double single quotation stuff but all result in the same error after trying many combinations and looking up answers all over I finally posted this question

Alchimie · Accepted Answer · 2020-05-17 19:21:19Z

1

data base name : data.db, table : table. try this , it worked well for me.

def updateNameById(id, val):
    connection = sqlite3.connect('data.db')
    connection.row_factory = sqlite3.Row
    cursor = connection.cursor()    
    cursor.execute('UPDATE table SET name=? WHERE id=?',(val,id,))
    connection.commit()

edited May 17, 2020 at 19:21

answered May 17, 2020 at 16:48

Alchimie

4265 silver badges14 bronze badges

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

Comments

OUBADI Ahmed · Accepted Answer · 2020-10-09 20:57:11Z

0

conn = sqlite3.connect("dbName")
cursor = conn.cursor()
def updateNameById(self, id, val):
    cursor.execute('UPDATE table SET name=? WHERE id=?',(val,id,))
    conn.commit()

answered Oct 9, 2020 at 20:57

OUBADI Ahmed

1623 silver badges4 bronze badges

Collectives™ on Stack Overflow

sqlite3.OperationalError: no such column: For update command in sqlite3 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