转载自：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用于字符串格式化
python中MySQL模块TypeError: %d format: a number is required, not str异常解决
原文：http://www.cnblogs.com/zl0372/p/python_mysqldb.html