How to use use bind variables in mysql and python

Question

I'm using mysql with python, I got an error when using a bind varialbe. Actually I don't know how to use a bind variable. Please help me with my problem.

Here is my code:

iouNo=textiv1.get()
    cursor.execute("UPDATE iou_table SET IOU_status=4 WHERE IOU_No= :iouNo",{'iouNo':iouNo})
    mydb.commit()

This is the error I got

mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':'iouNo'' at line 1

I want to use the iouNo variable inside the SQL query... How can I do it?

Does this answer your question? How can I insert data into a MySQL database? — ktzr
– ktzr, Commented Feb 14, 2021 at 17:13

nbk · Accepted Answer · 2021-02-14 17:06:49Z

0

You can read up on that iin the manual from MySQL.

%s is used as place holde.

If you only have one parameter or variable you still have tpo use a 2 dimensional tuple,

iouNo=textiv1.get()
cursor.execute("UPDATE iou_table SET IOU_status=4 WHERE IOU_No= %s;",(iouNo,))
mydb.commit()

answered Feb 14, 2021 at 17:06

nbk

49.6k8 gold badges32 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

How to use use bind variables in mysql and python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related