teratail
回答率
85.35%
teratail header banner
teratail header banner
質問するログイン新規登録
トップMySQLに関する質問あるカラムの値を、別のカラムの値によって、結果を表示する欄を変えたい。

編集履歴

回答編集履歴

3

見た目

2021/09/30 14:18

投稿

takanaweb5
takanaweb5

スコア359

test CHANGED
@@ -180,15 +180,15 @@
180
180
 
181
181
  | ------- | ---------- | ------------ | ---------- | ---------- | ------------ | ---------- |
182
182
 
183
- | A001 | 2021/09/21 | 11:28:00 | AAA | 2021/09/21 | 12:20:00 | BBB |
183
+ | A001 | 2021/09/21 | 11:28:00 | AAA | 2021/09/21 | 12:20:00 | BBB |
184
-
184
+
185
- | A001 | 2021/09/21 | 13:00:00 | BBB | 2021/09/21 | 13:30:00 | AAA |
185
+ | A001 | 2021/09/21 | 13:00:00 | BBB | 2021/09/21 | 13:30:00 | AAA |
186
-
186
+
187
- | A001 | 2021/09/22 | 23:26:00 | CCC | 2021/09/23 | 00:09:00 | DDD |
187
+ | A001 | 2021/09/22 | 23:26:00 | CCC | 2021/09/23 | 00:09:00 | DDD |
188
-
188
+
189
- | A001 | 2021/09/23 | 01:00:00 | DDD | NULL | NULL | NUL |
189
+ | A001 | 2021/09/23 | 01:00:00 | DDD | NULL | NULL | NULL |
190
-
190
+
191
- | A002 | 2021/09/21 | 01:00:00 | AAA | 2021/09/21 | 01:30:00 | CCC |
191
+ | A002 | 2021/09/21 | 01:00:00 | AAA | 2021/09/21 | 01:30:00 | CCC |
192
192
 
193
193
 
194
194
 

2

見た目

2021/09/30 14:17

投稿

takanaweb5
takanaweb5

スコア359

test CHANGED
@@ -92,23 +92,23 @@
92
92
 
93
93
  | ------- | ---------- | ---------- | -------- | ----------- | --------------- | ---------- | ---------- | ---------------- |
94
94
 
95
- | A001 | 1 | 2021/09/21 | 11:28:00 | AAA | 2 | 2021/09/21 | 12:20:00 | BBB |
95
+ |A001|1|2021/09/21|11:28:00|AAA|2 |2021/09/21|12:20:00|BBB |
96
-
96
+
97
- | A001 | 2 | 2021/09/21 | 12:20:00 | BBB | 1 | 2021/09/21 | 13:00:00 | BBB |
97
+ |A001|2|2021/09/21|12:20:00|BBB|1 |2021/09/21|13:00:00|BBB |
98
-
98
+
99
- | A001 | 1 | 2021/09/21 | 13:00:00 | BBB | 2 | 2021/09/21 | 13:30:00 | AAA |
99
+ |A001|1|2021/09/21|13:00:00|BBB|2 |2021/09/21|13:30:00|AAA |
100
-
100
+
101
- | A001 | 2 | 2021/09/21 | 13:30:00 | AAA | 1 | 2021/09/22 | 23:26:00 | CCC |
101
+ |A001|2|2021/09/21|13:30:00|AAA|1 |2021/09/22|23:26:00|CCC |
102
-
102
+
103
- | A001 | 1 | 2021/09/22 | 23:26:00 | CCC | 2 | 2021/09/23 | 00:09:00 | DDD |
103
+ |A001|1|2021/09/22|23:26:00|CCC|2 |2021/09/23|00:09:00|DDD |
104
-
104
+
105
- | A001 | 2 | 2021/09/23 | 00:09:00 | DDD | 1 | 2021/09/23 | 01:00:00 | DDD |
105
+ |A001|2|2021/09/23|00:09:00|DDD|1 |2021/09/23|01:00:00|DDD |
106
-
106
+
107
- | A001 | 1 | 2021/09/23 | 01:00:00 | DDD | « NULL » | « NULL » | « NULL » | « NULL » |
107
+ |A001|1|2021/09/23|01:00:00|DDD|NULL|NULL |NULL |NULL|
108
-
108
+
109
- | A002 | 1 | 2021/09/21 | 01:00:00 | AAA | 2 | 2021/09/21 | 01:30:00 | CCC |
109
+ |A002|1|2021/09/21|01:00:00|AAA|2 |2021/09/21|01:30:00|CCC |
110
-
110
+
111
- | A002 | 2 | 2021/09/21 | 01:30:00 | CCC | « NULL » | « NULL » | « NULL » | « NULL » |
111
+ |A002|2|2021/09/21|01:30:00|CCC|NULL|NULL |NULL |NULL|
112
112
 
113
113
 
114
114
 
@@ -180,15 +180,15 @@
180
180
 
181
181
  | ------- | ---------- | ------------ | ---------- | ---------- | ------------ | ---------- |
182
182
 
183
- | A001 | 2021/09/21 | 11:28:00 | AAA | 2021/09/21 | 12:20:00 | BBB |
183
+ | A001 | 2021/09/21 | 11:28:00 | AAA | 2021/09/21 | 12:20:00 | BBB |
184
-
184
+
185
- | A001 | 2021/09/21 | 13:00:00 | BBB | 2021/09/21 | 13:30:00 | AAA |
185
+ | A001 | 2021/09/21 | 13:00:00 | BBB | 2021/09/21 | 13:30:00 | AAA |
186
-
186
+
187
- | A001 | 2021/09/22 | 23:26:00 | CCC | 2021/09/23 | 00:09:00 | DDD |
187
+ | A001 | 2021/09/22 | 23:26:00 | CCC | 2021/09/23 | 00:09:00 | DDD |
188
-
188
+
189
- | A001 | 2021/09/23 | 01:00:00 | DDD | « NULL » | « NULL » | « NULL » |
189
+ | A001 | 2021/09/23 | 01:00:00 | DDD | NULL | NULL | NUL |
190
-
190
+
191
- | A002 | 2021/09/21 | 01:00:00 | AAA | 2021/09/21 | 01:30:00 | CCC |
191
+ | A002 | 2021/09/21 | 01:00:00 | AAA | 2021/09/21 | 01:30:00 | CCC |
192
192
 
193
193
 
194
194
 

1

誤植

2021/09/30 14:15

投稿

takanaweb5
takanaweb5

スコア359

test CHANGED
@@ -88,27 +88,29 @@
88
88
 
89
89
 
90
90
 
91
- | **uid** | **status** | **入場日** | **入場時間** | **入場駅** | **lead_status** | **出場日** | **出場時間** | **出場駅** |
91
+ | **uid** | **status** | **d** | **t** | **station** | **lead_status** | **lead_d** | **lead_t** | **lead_station** |
92
-
92
+
93
- | ------- | ---------- | ---------- | ------------ | ---------- | --------------- | ---------- | ------------ | ---------- |
93
+ | ------- | ---------- | ---------- | -------- | ----------- | --------------- | ---------- | ---------- | ---------------- |
94
-
94
+
95
- | A001 | 1 | 2021/09/21 | 11:28:00 | AAA | 2 | 2021/09/21 | 12:20:00 | BBB |
95
+ | A001 | 1 | 2021/09/21 | 11:28:00 | AAA | 2 | 2021/09/21 | 12:20:00 | BBB |
96
-
96
+
97
- | A001 | 2 | 2021/09/21 | 12:20:00 | BBB | 1 | 2021/09/21 | 13:00:00 | BBB |
97
+ | A001 | 2 | 2021/09/21 | 12:20:00 | BBB | 1 | 2021/09/21 | 13:00:00 | BBB |
98
-
98
+
99
- | A001 | 1 | 2021/09/21 | 13:00:00 | BBB | 2 | 2021/09/21 | 13:30:00 | AAA |
99
+ | A001 | 1 | 2021/09/21 | 13:00:00 | BBB | 2 | 2021/09/21 | 13:30:00 | AAA |
100
-
100
+
101
- | A001 | 2 | 2021/09/21 | 13:30:00 | AAA | 1 | 2021/09/22 | 23:26:00 | CCC |
101
+ | A001 | 2 | 2021/09/21 | 13:30:00 | AAA | 1 | 2021/09/22 | 23:26:00 | CCC |
102
-
102
+
103
- | A001 | 1 | 2021/09/22 | 23:26:00 | CCC | 2 | 2021/09/23 | 00:09:00 | DDD |
103
+ | A001 | 1 | 2021/09/22 | 23:26:00 | CCC | 2 | 2021/09/23 | 00:09:00 | DDD |
104
-
104
+
105
- | A001 | 2 | 2021/09/23 | 00:09:00 | DDD | 1 | 2021/09/23 | 01:00:00 | DDD |
105
+ | A001 | 2 | 2021/09/23 | 00:09:00 | DDD | 1 | 2021/09/23 | 01:00:00 | DDD |
106
-
106
+
107
- | A001 | 1 | 2021/09/23 | 01:00:00 | DDD | « NULL » | « NULL » | « NULL » | « NULL » |
107
+ | A001 | 1 | 2021/09/23 | 01:00:00 | DDD | « NULL » | « NULL » | « NULL » | « NULL » |
108
-
108
+
109
- | A002 | 1 | 2021/09/21 | 01:00:00 | AAA | 2 | 2021/09/21 | 01:30:00 | CCC |
109
+ | A002 | 1 | 2021/09/21 | 01:00:00 | AAA | 2 | 2021/09/21 | 01:30:00 | CCC |
110
-
110
+
111
- | A002 | 2 | 2021/09/21 | 01:30:00 | CCC | « NULL » | « NULL » | « NULL » | « NULL » |
111
+ | A002 | 2 | 2021/09/21 | 01:30:00 | CCC | « NULL » | « NULL » | « NULL » | « NULL » |
112
+
113
+
112
114
 
113
115
 
114
116