![python中MySQL模块TypeError: %d format: a number is required, not str异常解决 python中MySQL模块TypeError: %d format: a number is required, not str异常解决](https://image.shishitao.com:8440/aHR0cHM6Ly9ia3FzaW1nLmlrYWZhbi5jb20vdXBsb2FkL2NoYXRncHQtcy5wbmc%2FIQ%3D%3D.png?!?w=700&webp=1)
转载自: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, '', '')
n = cursor.execute(attr_sql, param)
python执行上面的语句会报下面的错误:%d format: a number is required, not str。
最终在*查到了问题的解决方案
http://*.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用于字符串格式化