python - 使用 Python MYSQL.Connector 插入 MySQL 表时出现错误

Question

这是我的代码:

sql = "INSERT INTO haircolor (x_pos, y_pos, width, height,filename,hair_color) VALUES (%s, %s, %s, %s, %s, %s)"

print ("Values",(x_pos, y_pos, width, height,filename,hair_color))
mycursor.execute(sql, (x_pos, y_pos, width, height,filename,hair_color))
mydb.commit()

输出:

Values: 33.897543, 28.304444444444444, 2.7566544, 4.9043634, '1 (copy1).jpg,black`

错误

Failed processing format-parameters python 'str_' cannot be converted to a mysql type

Answer 1

在我看来，好像你的文件名和头发颜色变量中有未转义的反引号......这不会有任何帮助......