質問編集履歴
1
マークダウン記法使用
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -1,44 +1,44 @@
|
|
|
1
1
|
仮に以下のようなテーブルがあったとして
|
|
2
2
|
|
|
3
|
-
|
|
3
|
+
|列1|列2|列3|
|
|
4
4
|
|
|
5
5
|
table:a
|
|
6
6
|
|
|
7
|
-
|
|
7
|
+
```
|
|
8
8
|
|
|
9
|
-
store revision
|
|
9
|
+
|store |revision|deposit |tsubo |
|
|
10
10
|
|
|
11
|
-
UDON 1 4,143,600 [NULL]
|
|
11
|
+
|UDON |1 |4,143,600 |[NULL] |
|
|
12
12
|
|
|
13
|
-
UDON 2 4,143,600 [NULL]
|
|
13
|
+
|UDON |2 |4,143,600 |[NULL] |
|
|
14
14
|
|
|
15
|
-
UDON 3 4,143,600 [NULL]
|
|
15
|
+
|UDON |3 |4,143,600 |[NULL] |
|
|
16
16
|
|
|
17
|
-
UDON 4 4,143,600 180000
|
|
17
|
+
|UDON |4 |4,143,600 |180000 |
|
|
18
18
|
|
|
19
|
-
Mac 1 2,152,400 [NULL]
|
|
19
|
+
|Mac |1 |2,152,400 |[NULL] |
|
|
20
20
|
|
|
21
|
-
Mac 2 2,152,400 [NULL]
|
|
21
|
+
|Mac |2 |2,152,400 |[NULL] |
|
|
22
22
|
|
|
23
|
-
Mac 3 2,152,400 [NULL]
|
|
23
|
+
|Mac |3 |2,152,400 |[NULL] |
|
|
24
24
|
|
|
25
|
-
Mac 4 2,152,400 [NULL]
|
|
25
|
+
|Mac |4 |2,152,400 |[NULL] |
|
|
26
26
|
|
|
27
|
-
Mac 5 2,152,400 [NULL]
|
|
27
|
+
|Mac |5 |2,152,400 |[NULL] |
|
|
28
28
|
|
|
29
|
-
Mac 6 2,152,400 250000
|
|
29
|
+
|Mac |6 |2,152,400 |250000 |
|
|
30
30
|
|
|
31
|
-
TENPURA
|
|
31
|
+
|TENPURA|1 |1,234,500 |[NULL] |
|
|
32
32
|
|
|
33
|
-
TENPURA
|
|
33
|
+
|TENPURA|2 |1,234,500 |[NULL] |
|
|
34
34
|
|
|
35
|
-
TENPURA
|
|
35
|
+
|TENPURA|3 |1,234,500 |[NULL] |
|
|
36
36
|
|
|
37
|
-
TENPURA
|
|
37
|
+
|TENPURA|4 |1,234,500 |[NULL] |
|
|
38
38
|
|
|
39
|
-
TENPURA
|
|
39
|
+
|TENPURA|5 |1,234,500 |120000 |
|
|
40
40
|
|
|
41
|
-
|
|
41
|
+
```
|
|
42
42
|
|
|
43
43
|
やりたいことは「store」ごとにstoreのmax「revision」を
|
|
44
44
|
|
|
@@ -56,7 +56,7 @@
|
|
|
56
56
|
|
|
57
57
|
うまくいかず、どうすればよいかご教授頂きたいです。
|
|
58
58
|
|
|
59
|
-
|
|
59
|
+
```
|
|
60
60
|
|
|
61
61
|
update table_a a1
|
|
62
62
|
|
|
@@ -71,3 +71,5 @@
|
|
|
71
71
|
on a2.store = amax.store
|
|
72
72
|
|
|
73
73
|
and a2.revision = amax.revision
|
|
74
|
+
|
|
75
|
+
```
|