How to pass multiple variables in python flask to mysqldb?

Question

I have tried to apply the advice in this question but I still don't seem to get the code to work. I am trying to pass two variables

How to pass variables in python flask to mysqldb?

cur = mysql.connection.cursor()
for row in jdict:
  headline = row['title']
  url = row['url']
  cur.execute("INSERT INTO headlinetitles (Title, Url) VALUES ('%s','%s');",str(headline),str(url))
mysql.connection.commit()

I get the error TypeError: execute() takes from 2 to 3 positional arguments but 4 were given

Christopher · Accepted Answer · 2020-12-20 17:18:11Z

1

I found the solution. Maybe this will help someone.

cur = mysql.connection.cursor()
for row in jdict:
    headline = row['title']
    url = row['url']
    sqldata = ("INSERT INTO headlinetitles (Title, Url) VALUES ('%s','%s');",str(headline),str(url))
    cur.execute = (sqldata)
mysql.connection.commit()

answered Dec 20, 2020 at 17:18

Christopher

6473 gold badges9 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

How to pass multiple variables in python flask to mysqldb?

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related