python中MySQL模块TypeError: %d format: a number is required, not str异常解决

转载自：http://www.codeif.com/topic/896

python代码:

attr_sql = "INSERT INTO `ym_attribute` (`attr_name`, `type_id`, `attr_value`, `attr_show`, `attr_sort`) VALUES(%s, %s, %s, %s, %s)"
param = (product_attr, type_id, product_attr_v, '1', '1')
n = cursor.execute(attr_sql, param)

python执行上面的语句会报下面的错误:%d format: a number is required, not str。

最终在stackoverflow查到了问题的解决方案 
http://stackoverflow.com/questions/5785154/python-mysqldb-issues

答案为:The format string is not really a normal Python format string. You must always use %s for all fields. 也就是MySQLdb的字符串格式化不是标准的python的字符串格式化,应当一直使用%s用于字符串格式化