execute - AttributeError：“MySQLConnection”对象没有“执行”属性

Question

我在选择 * 有 ID 的人时遇到错误。错误说“AttributeError：'MySQLConnection'对象没有属性'execute'”。下面是代码：

import mysql.connector

def insertOrUpdate(id, name):
# tạo đối tượng connection
conn = mysql.connector.connect(host = "localhost", user = "root", 
passwd = "", database = "database")

query = "SELECT * FROM people WHERE ID = "+str(id)
cursor = conn.cursor()
cursor.execute(query)
isRecordExist = 0

for row in cursor:
    isRecordExist = 1
if(isRecordExist == 0):
    query = "INSERT INTO people(ID,Name) VALUES("+str(id)+",'"+ str(name)+"')"
else:
    query = "UPDATE people SET Name = '"+str(name)+"' WHERE ID = "+str(id)
conn.execute(query)
conn.commit()
conn.close()

在此处输入图像描述 请帮助

标签： executemysqlconnection