這可能嗎？
booking_details = []
for_quicksort = [1, 5, 9, 11, 19]
for i in range(len(for_quicksort)):
fetch_booking_details = cursor.execute("SELECT * FROM booking WHERE customer_id=?", (for_quicksort(i)))
booking_details.append(fetch_booking_details)
TypeError：“串列”物件不可呼叫
uj5u.com熱心網友回復：
for_quicksort(i)
據我所知，您只是使用了錯誤型別的括號。要索引串列，請使用方括號[]。圓括號()用于呼叫函式（以及將資料包含在某些資料結構中，如元組）。
更正：
for_quicksort[i]
uj5u.com熱心網友回復：
遍歷串列 (for_quicksort)。無需顯式索引。
booking_details = []
for_quicksort = [1, 5, 9, 11, 19]
for cust_id in for_quicksort:
cursor.execute("SELECT * FROM booking WHERE customer_id=%s", [cust_id])
for row in cursor.fetchall():
booking_details.append(row)
uj5u.com熱心網友回復：
您不需要回圈，您可以在一個查詢中獲取所有詳細資訊：
for_quicksort = [1, 5, 9, 11, 19]
for i in range(len(for_quicksort)):
fetch_booking_details = cursor.execute(
"SELECT * FROM booking WHERE customer_id IN (?, ?, ?, ?, ?)",
(for_quicksort,)
)
booking_details = fetch_booking_details.fetchall()
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/434085.html