Problems with Python MySQLdb (TypeError:% d format: number is required, not str)

Question

I am trying to perform the following insert operation:

cursor.execute(""" insert into tree (id,parent_id,level,description,code,start,end) values (%d,%d,%d,%s,%s,%f,%f) """, (1,1,1,'abc','def',1,1) ) 

The structure of my MYSQL table:

 id int(255), parent_id int(255), level int(11), description varchar(255), code varchar(255), start decimal(25,4), end decimal(25,4) 

However, when I run my program, I get an error

"File" / usr / lib / pymodules / python 2.6 / MySQLdb / cursors.py ", line 151, executed by query = query% db.literal (args)

TypeError: format% d: number is required, not str "

Answer 1

The format string is not really a regular Python format string. You should always use %s for all fields.

Answer 2

try the following:

 cursor.execute(""" insert into tree (id,parent_id,level,description,code,start,end) values (%s,%s,%s,'%s','%s',%s,%s) """%(1,1,1,'abc','def',1,1) ) 

Answer 3

Since its data is in integer or decimal format, as you can use% s, which is usually used for string format,% d or% I should use for integer or decimal values.

Answer 4

Whenever you see errors of this type, you should use the type () function to check the types of values ​​or variables .... and you will see the type is - 'str'. This means that Python accepts all values ​​in strings (the default data type is string). Therefore, the error says that% d is for numbers, not strings. Therefore, consider% s in python for all field types.

Answer 5

I got the same error, but that was for a different reason. The problem was that the string contained the "%" character and this was confusing to Python:

 TemplateStr = '[....] % discount rate [....] %s and %s print TemplateStr % ('abc', 'def') 

Python interpreted this “% discount” as “% d” and kept complaining because I fed it with a string ('abc') rather than a number.

It took me a long time to figure this out!

(The solution is to enter %% instead of%.)

Answer 6

Here we rather write & d, set% s for everything.