回答編集履歴

2022/12/21 08:59

投稿

スコア19749

test CHANGED Viewed

@@ -12,10 +12,10 @@
 # テーブルのカラム名を取得
 columns = [r[1] for r in conn.execute(f'PRAGMA table_info({tbl});').fetchall()]
 # UPDATE ステートメントの column = "value" 部分を作成
-stmt = ','.join(f'{c} = "{v}"' for c, v in zip(columns, lst))
+stmt = ','.join(f'{c} = ?' for c in columns)
 a = 'テスト'
-cur.execute(f'UPDATE {tbl} SET {stmt} WHERE col1 = "{a}"')
+cur.execute(f'UPDATE {tbl} SET {stmt} WHERE col1 = ?', lst[:len(columns)] + [a])
 conn.commit()
 conn.close()