擅长:python、mysql、java
<p>您是否确保先将其转化为一份准备好的声明?请参阅文档示例<a href="https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorprepared.html" rel="nofollow noreferrer">here</a>-</p>
<pre><code>cursor = cnx.cursor(prepared=True)
stmt = "SELECT fullname FROM employees WHERE id = %s" # (1)
cursor.execute(stmt, (5,))
</code></pre>
<p>否则,如果您只想执行直接字符串操作,则应该执行以下操作</p>
<pre><code>query = 'INSERT INTO batch_details (batch_id,plant_id,product_code) VALUES ("%s","%s","%s")'%(id, plantcode, pcode)
cursor.execute(query)
</code></pre>