質問編集履歴
1
内容修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -7,7 +7,7 @@
|
|
|
7
7
|
tr = (a,b,c,d,e,f,g,h,i)
|
|
8
8
|
poc = tr[1]
|
|
9
9
|
|
|
10
|
-
sql_update =" UPDATE
|
|
10
|
+
sql_update =" UPDATE TEST_TABLE SET A= %s, B = %s, C = %s, D = %s, E = %s, F = %s, G = %s, H = %s, I = I+1, J = cast(now() as datetime) " +\
|
|
11
11
|
"WHERE B = %s "
|
|
12
12
|
cursor.execute(sql_update,(tr,poc))
|
|
13
13
|
```
|