擅长:python、mysql、java
<p>尝试删除<code>%s</code>周围的单引号,您应该将<code>%s</code>的值作为元组传递</p>
<pre><code>def deleteItem():
goneItem = input("Enter item: ")
removeItem = "DELETE FROM amazon_items WHERE itemName = %s"
mycursor.execute(removeItem, (goneItem,))
db.commit()
print(mycursor.rowcount, "item removed")
</code></pre>