MySQLdb Python insert %d and %s

Question

Precursor:

MySQL Table created via: CREATE TABLE table(Id INT PRIMARY KEY NOT NULL, Param1 VARCHAR(50)) 

Function:

.execute("INSERT INTO table VALUES(%d,%s)", (int(id), string) 

Output:

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

I'm not sure what's going on here or why I am not able to execute the command. This is using MySQLdb in Python. .execute is performed on a cursor object.

EDIT:

The question: Python MySQLdb issues (TypeError: %d format: a number is required, not str) says that you must use %s for all fields. Why might this be? Why does this command work?

.execute("INSERT INTO table VALUES(%s,%s)", (int(id), string) 

Answer 1

As the whole query needs to be in a string format while execution of query so %s should be used...

After query is executed integer value is retained.

So your line should be.

.execute("INSERT INTO table VALUES(%s,%s)", (int(id), string)) 

Explanation is here

Answer 2

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