MySQL db call: not all arguments converted during string formatting

Question

I get the error not all arguments converted during string formatting, when I execute the below-given code:

pro_title = "FSBT"
print "pro_title: " + pro_title
pro_id_query = "SELECT ID FROM projs WHERE pro_title=%s"
cursor.execute(pro_id_query, pro_title)
db.commit()
row = cursor.fetchone()
pro_id = None
if row is not None:
   pro_id = str(row[0])    
print "pro_id: " + pro_id

I also tried format:

pro_id_query = "SELECT ID FROM projs WHERE title={}"
cursor.execute(pro_id_query.format(pro_title))

It only works when I use ' around {}:

pro_id_query = "SELECT ID FROM projs WHERE title='{}'"
cursor.execute(pro_id_query.format(pro_title))

I do not understand why INSERT queries work well with %s, while SELECT queries do not:

insert_query = "INSERT INTO projs (title, description) VALUES (%s, %s) ON DUPLICATE KEY UPDATE `title`=%s"
cursor.execute(insert_query, (pro_title, pro_description, pro_title))

Try pro_id_query = "SELECT ID FROM projs WHERE pro_title=?" cursor.execute(pro_id_query, (pro_title,)); — angel.bonev
– angel.bonev, Commented Feb 4, 2018 at 13:38
@angel.bonev: I get the error not all arguments converted during string formatting — Markus
– Markus, Commented Feb 4, 2018 at 15:22

An0n · Accepted Answer · 2018-02-04 16:15:52Z

1

pro_title = "FSBI" 
pro_id_query = "SELECT * FROM %s"%(pro_title)
cursor = con.cursor() 
cursor.execute(q) 
result_list = result.fetchall()   
result_list[0][0] 
con.commit() 
con.close()

pro_id_query = cursor.fetchone() while row != False:
print ("The ID is : ", row[0])

*edit

id = input("Id : ")
name = input("Name : ")
cursor = con.cursor()
cursor.execute(""" INSERT INTO names (id, name) VALUES("%s", "%s")"""
          %(id, name))

edited Feb 4, 2018 at 16:15

answered Feb 4, 2018 at 14:13

An0n

7436 silver badges20 bronze badges

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

4 Comments

An0n Over a year ago

If you assign the last line to a variable it does.

Markus Over a year ago

Which line? This one pro_id_query = "SELECT * FROM %s"%(pro_title)?

Markus Over a year ago

If you refer to this line, I get the error INSERT INTO projs (title, description) VALUES (TES, TES) ON DUPLICATE KEY UPDATE title=TES (1054, "Unknown column 'TES' in 'field list'")

An0n Over a year ago

I edited my answer with input aswell. But it does work. I dont know how you have made your table offcourse, then i need to make everything a variable to fix it so that you can put it in manualy. Im sure you can figure it out.

Collectives™ on Stack Overflow

MySQL db call: not all arguments converted during string formatting

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related