python查询报%d format: a number is required, not str问题

插入语句：insert_sql = "INSERT INTO Equipment(id, Eudid, Ename, Eversion, Estate) VALUES (%d, %s, %s, %s, %s)"

插入数据：insert_data = [(5, '5', 'Xiaomi_MI 8', '9', 'available')]

执行插入：db.insertSQL(insert_sql, insert_data)

插入实现：def insertSQL(self, sql, data):
    try:
        self.cs.executemany(sql, data)
        # 你必须调用 commit() 来保持你数据的提交如果你没有将自动提交设置为true
        self.conn.commit()
    except Exception as e:
        # 发生错误时回滚
        self.conn.rollback()
        print("插入SQL错误：%s" % e)

 

解决方法：

VALUES (%s, %s, %s, %s, %s)
insert_data = [('5', '5', 'Xiaomi_MI 8', '9', 'available')]

全部改为s%，重新尝试插入，解决问题