How to use python variables in MySQL Insert statement, i am getting a tuple error, Please suggest

Question

import MySQLdb
name="XYZ"
number=(256, 34576312114897154715004917944343995880721156274004613128261928143013598386679L)
db=MySQLdb.Connect("localhost","root","12345","phone")
cursor=db.cursor()
sql= ("""INSERT INTO phonebook(number, Mobile) VALUES(%s,%s)""" , name,number)
cursor.execute(sql)
db.commit()
db.close()

"Failed processing format-parameters; %s" % err) mysql.connector.errors.ProgrammingError: Failed processing format-parameters; Python 'tuple' cannot be converted to a MySQL type

KbiR · Accepted Answer · 2018-07-07 11:21:45Z

2

Your sql variable is a tuple

sql= ("""INSERT INTO phonebook(number, Mobile) VALUES(%s,%s)""" , name,number)

So when it try to execute, cursor.execute(sql) (where sql is tuple) it give error Python 'tuple' cannot be converted to a MySQL type

Please use string.

sql = """INSERT INTO phonebook(number, Mobile) VALUES(%s,%s)""" % (name,number)

edited Jul 7, 2018 at 11:21

KbiR

4,2246 gold badges44 silver badges120 bronze badges

answered May 29, 2015 at 6:50

NPatel

21.4k17 gold badges104 silver badges166 bronze badges

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

Collectives™ on Stack Overflow

How to use python variables in MySQL Insert statement, i am getting a tuple error, Please suggest

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