代码如下(我是Python / Mysql的新手):

import mysql.connector

conn = mysql.connector.connect(host='localhost',user='user1',password='puser1',db='mm')
cursor = conn.cursor()
string1 = 'test1'
insert_query = """INSERT INTO items_basic_info (item_name) VALUES (%s)""", (string1)
cursor.execute(insert_query)
conn.commit()


当我运行此代码时,出现以下错误:

Traceback (most recent call last)
File "test3.py", line 9, in <module>
cursor.execute(insert_query)
File "C:\Users\Emanuele-PC\AppData\Local\Programs\Python\Python36\lib\site-packages\mysql\connector\cursor.py", line 492, in execute
stmt = operation.encode(self._connection.python_charset)
AttributeError: 'tuple' object has no attribute 'encode'


对于这个问题,我看到了不同的答案,但案件与我的案件完全不同,我无法真正理解自己在哪里犯错。谁能帮我?

最佳答案

对于avoid SQL-injections Django documentation,完全建议使用如下占位符:

import mysql.connector

conn = mysql.connector.connect(host='localhost',user='user1',password='puser1',db='mm')
cursor = conn.cursor()
string1 = 'test1'
insert_query = """INSERT INTO items_basic_info (item_name) VALUES (%s)"""
cursor.execute(insert_query, (string1,))
conn.commit()


您必须在execute方法中传递元组/列表参数作为第二个参数。一切都应该没事。

关于python - 'tuple'对象没有属性'encode',我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/46019616/

10-11 06:44
查看更多