Errors updating a record in Python

Question

I am trying to do a simple update in python. This the code I try to run:

 mycursor = mydb.cursor()
 if(result<5):
        os.remove(destiny)
        print(result)
        print(fi[:-4])
        print(lastid)
        sql = "UPDATE googlesearch SET similarity=%s WHERE tweetid=%d and imageName=%s"
        value = (str(result),lastid,str(fi[:-4]))
        print(value)
        mycursor.execute(sql, value)
        mydb.commit()

As you can see it is very easy. But when I run it, I have this error:

ProgrammingError: Not all parameters were used in the SQL statement

Printing values, I have this: ('2.82258064516129', 2636, 'dimg_10') And working in Navicat with this sentence, everything is perfect. So why, I have this error?.

Statement parameters positions are indicated by %s, not %d. — khelwood
– khelwood, Commented Jun 15, 2020 at 21:36

khelwood · Accepted Answer · 2020-06-15 21:40:04Z

1

Statement parameter positions are indicated by %s, not %d.

So I think if you change

sql = "UPDATE googlesearch SET similarity=%s WHERE tweetid=%d and imageName=%s"
                                                            ^

to

sql = "UPDATE googlesearch SET similarity=%s WHERE tweetid=%s and imageName=%s"
                                                            ^

you will avoid this error.

answered Jun 15, 2020 at 21:40

khelwood

59.7k14 gold badges91 silver badges116 bronze badges

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

Collectives™ on Stack Overflow

Errors updating a record in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related