我正在創建一個 Python 腳本來在表中插入一些記錄，但是有以下問題：
INSERT INTO orders VALUES (7656940929251, "ADIDAS | KID'S STAN SMITH")
,(242345235233, 'ADIDAS | CLASSIC BACKPACK')
我收到錯誤訊息：“列名 'ADIDAS | KID'S STAN SMITH' 無效
如何用 Python 解決這個問題？
uj5u.com熱心網友回復：
假設這是您的元組：
tuples_v3s = ((7656941224163, 'ADIDAS | CLASSIC BACKPACK'),
(7656941256931, 'ADIDAS | CLASSIC BACKPACK | LEGEND INK MULTICOLOUR'),
(7656940929251, "ADIDAS | KID'S STAN SMITH"))
for tuples_v3 in tuples_v3s:
print(f"""INSERT INTO orders VALUES ({tuples_v3[0]},'{tuples_v3[1].replace("'","''")}' ) """)
#INSERT INTO orders VALUES (7656941224163,'ADIDAS | CLASSIC BACKPACK' )
#INSERT INTO orders VALUES (7656941256931,'ADIDAS | CLASSIC BACKPACK | LEGEND INK MULTICOLOUR' )
#INSERT INTO orders VALUES (7656940929251,'ADIDAS | KID''S STAN SMITH' )
uj5u.com熱心網友回復：
如果您使用的是 psycopg2，請按以下方式更新您的查詢
insert_query = "INSERT INTO products VALUES (7656941224163, %s),
(7656941256931, %s),
(7656940929251, %s)"
cur.execute(insert_query, ("ADIDAS | CLASSIC BACKPACK", "ADIDAS | CLASSIC BACKPACK | LEGEND INK MULTICOLOUR", "ADIDAS | KID'S STAN SMITH"))
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/467738.html
上一篇：<>與多個值相比如何作業？
下一篇：回圈瀏覽列并且更改值為空