Python correct way to assign variables to MYSQL query?

Question

What are different ways to reference a Python variable into MySQL statement?

I know you can reference like this:

var = "String"

cursor.execute("select * from table where column1 = %s") % (var)

I saw somebody mention to use ?. What are other ways to do it?

Your statement above is totally incorrect.

Booboo
– Booboo

2020-01-20 12:47:13 +00:00
Commented Jan 20, 2020 at 12:47 — Booboo
– Booboo, Commented Jan 20, 2020 at 12:47

Nathan · Accepted Answer · 2020-01-20 12:39:49Z

4

You can do this by passing parameters:

cursor = connection.cursor(prepared=True)
sql_insert_query = """ INSERT INTO Employee
                       (id, Name, Joining_date, salary) VALUES (%s,%s,%s,%s)"""

insert_tuple_1 = (1, "Json", "2019-03-23", 9000)
cursor.execute(sql_insert_query, insert_tuple_1)
connection.commit()

Example taken from here

answered Jan 20, 2020 at 12:39

Nathan

3,6482 gold badges21 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Python correct way to assign variables to MYSQL query?

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