You need to enable JavaScript to run this app. Python基于mysql.connector执行DELETE报Unread result found错误
优惠活动
大模型
产品
解决方案
定价
更多

Python基于mysql.connector执行DELETE报Unread result found错误

Python连接MySQL开发报错排查

现有数据库初始化代码

import mysql.connector
mydb = mysql.connector.connect(host="localhost", user="root", password="root")
# 建库建表逻辑
mycursor = mydb.cursor()
mycursor.execute("create database if not exists store")
mycursor.execute("use store")
mycursor.execute("create table if not exists signup(username varchar(20),password varchar(20))")
mycursor.execute("create table if not exists buynewbooks(nameofbook varchar(30))")
mycursor.execute("create table if not exists feedback(rating varchar(11))")

触发报错的删除账号功能片段

# 删除账号分支
elif ch == 3:
    mycursor.execute("select username from signup")
    u = str(input("enter your registerd USERNAME"))   
    p = str(input("enter your account password"))
    sql = "DELETE FROM signup WHERE username = u AND password = p" 
    mycursor.execute(sql)
    mydb.commit
    print("your account has been removed")

完整报错栈

Traceback (most recent call last):
  File "C:/Users/win10/.spyder-py3/kj7.py", line 34, in <module>
    mycursor.execute(sql)
  File "C:\Users\win10\AppData\Local\Programs\Python\Python38-32\lib\site-packages\mysql\connector\cursor.py", line 547, in execute
    self._connection.handle_unread_result()
  File "C:\Users\win10\AppData\Local\Programs\Python\Python38-32\lib\site-packages\mysql\connector\connection.py", line 1286, in handle_unread_result
    raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found

问题定位与修正方案

  • 直接触发报错的原因:执行完mycursor.execute("select username from signup")后,没有读取该查询返回的结果集,就复用同一个cursor执行下一条SQL,MySQL connector检测到存在未处理的结果集,主动抛出异常阻断后续操作。且这段select查询没有被实际用于校验逻辑,属于冗余代码
  • 隐藏逻辑问题1:DELETE语句中的u、p是SQL层面的字面量字符,并非Python代码中读取的输入变量,即便不触发报错,也无法匹配到对应用户数据
  • 隐藏逻辑问题2:mydb.commit缺少括号,方法未被实际执行,删除操作不会持久化写入数据库

修正后的分支代码参考:

elif ch == 3:
    u = str(input("enter your registered USERNAME"))   
    p = str(input("enter your account password"))
    # 使用参数化查询,避免SQL注入,正确传入输入变量
    sql = "DELETE FROM signup WHERE username = %s AND password = %s"
    mycursor.execute(sql, (u, p))
    # 补全commit方法调用,触发事务提交
    mydb.commit()
    print("your account has been removed")

补充说明:如果业务逻辑确实需要在删除前做查询校验,必须在查询后调用mycursor.fetchall()将结果集读取完毕,再执行后续SQL操作,否则仍会触发未读结果集报错。

内容的提问来源于stack exchange,提问作者kjforever

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.11.05 16:06:07