回答率: 85.30%

質問するログイン新規登録

トップ MySQLに関する質問 case文とwhere文の併用

編集履歴

回答編集履歴

3

修正

2018/05/10 02:06

投稿

スコア25430

answer CHANGED Viewed

@@ -10,6 +10,6 @@
 WHERE id = 176
    or (
           not exists(select 1 from cp_plan where id = 176)
-      and id in (select mid from (SELECT max(id) as mid from cp_plan) as tmp)
+      and id = (select mid from (SELECT max(id) as mid from cp_plan) as tmp)
       )
 ```

2

修正

2018/05/10 02:06

投稿

スコア25430

answer CHANGED Viewed

@@ -10,6 +10,6 @@
 WHERE id = 176
    or (
           not exists(select 1 from cp_plan where id = 176)
-      and id=(select mid from (SELECT max(id) as mid from cp_plan) as tmp)
+      and id in (select mid from (SELECT max(id) as mid from cp_plan) as tmp)
       )
 ```

1

修正

2018/05/10 01:58

投稿

スコア25430

answer CHANGED Viewed

@@ -10,6 +10,6 @@
 WHERE id = 176
    or (
           not exists(select 1 from cp_plan where id = 176)
-      and id=(SELECT max(id) from cp_plan)
+      and id=(select mid from (SELECT max(id) as mid from cp_plan) as tmp)
       )
 ```