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
相关产品推荐
相关产品推荐

