我的代碼
倒數第二行顯示錯誤 <Unread.result.found> 但是當我單獨運行它時，它運行成功
import mysql.connector as msqc
import numpy as np
db = msqc.connect(
host="localhost",
username="root",
password=" ",
database="hotel",
)
cur = db.cursor()
ss = 'SELECT one_bed ,Available_one_bed from rooms where Available_one_bed = "A" '
cur.execute(ss)
available_room = cur.fetchone()
print(available_room[0])
cur.execute('SELECT * from rooms')
s = 'UPDATE rooms SET Available_one_bed = "N/A" WHERE one_bed = ' str(100)
cur.execute(s)
uj5u.com熱心網友回復：
很可能不是第一次執行后讀取的所有資料。您需要一個緩沖游標，例如
cur = db.cursor(buffered=True)
一些細節可以在這里找到https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorbbuffered.html
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/415088.html
標籤：