Python MySQL insert into with parameter

Question

I am having a hard time using the MySQLdb module to insert information into my database. I need to insert 2 variables into the table.My table is userid,the type of user_id is varchar,the type of count is int.

  SQL = 'select user_id,count(*)AS num from client1 group by user_id order by count(*) desc;'
  for row in cursor.execute(SQL):
       a = row.user_id
       b = row.num
       cursormysql.execute("insert into userid(user_id,count) VALUES (%s,%s))",(a,b))
       db.commit()

Please edit your question to include your code and the error as text, rather than images. Imagine the one person who is able to help you is very busy and won't bother waiting for images to load to answer a question. — Wai Ha Lee
– Wai Ha Lee, Commented Feb 5, 2016 at 2:55

aphodius · Accepted Answer · 2016-02-05 03:22:14Z

1

Your parenthesis do not match on cursormysql.execute("insert into userid(user_id,count) VALUES (%s,%s))",(a,b))

Try like cursormysql.execute("insert into userid(user_id,count) VALUES (%s,%s)",(a,b))

edited Feb 5, 2016 at 3:22

answered Feb 5, 2016 at 3:13

aphodius

1,24919 silver badges33 bronze badges

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

1 Comment

aphodius Over a year ago

) right before double quotes see my updated answer

Collectives™ on Stack Overflow

Python MySQL insert into with parameter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related