回答編集履歴
1
訂正
answer
CHANGED
|
@@ -1,7 +1,7 @@
|
|
|
1
1
|
UPDATE main_table SET hantei =:hantei WHERE id** = IN (id_a=:id_a,id_b=:id_b)**
|
|
2
2
|
SQLの文法上、太字の部分が誤っています。
|
|
3
3
|
|
|
4
|
-
UPDATE main_table SET hantei =:hantei WHERE id IN (:id_a, id_b)
|
|
4
|
+
UPDATE main_table SET hantei =:hantei WHERE id IN (:id_a, :id_b)
|
|
5
5
|
とか、
|
|
6
6
|
UPDATE main_table SET hantei =:hantei WHERE id_a = :id_a AND id_b = :id_b
|
|
7
7
|
って書き方はあります。
|