回答編集履歴
4
文法の修正
test
CHANGED
@@ -66,16 +66,6 @@
|
|
66
66
|
|
67
67
|
) d
|
68
68
|
|
69
|
-
order by
|
70
|
-
|
71
|
-
a.id_number,
|
72
|
-
|
73
|
-
b.status,
|
74
|
-
|
75
|
-
c.create_add,
|
76
|
-
|
77
|
-
d.creator
|
78
|
-
|
79
69
|
;
|
80
70
|
|
81
71
|
```
|
3
文法の修正
test
CHANGED
@@ -38,7 +38,7 @@
|
|
38
38
|
|
39
39
|
・・・
|
40
40
|
|
41
|
-
select
|
41
|
+
select 20 as status
|
42
42
|
|
43
43
|
) b
|
44
44
|
|
2
書式の改善
test
CHANGED
@@ -18,51 +18,51 @@
|
|
18
18
|
|
19
19
|
from (
|
20
20
|
|
21
|
-
select 1 id_number union all
|
21
|
+
select 1 as id_number union all
|
22
22
|
|
23
|
-
select 2 id_number union all
|
23
|
+
select 2 as id_number union all
|
24
24
|
|
25
|
-
select 3 id_number union all
|
25
|
+
select 3 as id_number union all
|
26
26
|
|
27
27
|
・・・
|
28
28
|
|
29
|
-
select 25 id_number
|
29
|
+
select 25 as id_number
|
30
30
|
|
31
31
|
) a
|
32
32
|
|
33
33
|
cross join (
|
34
34
|
|
35
|
-
select 1 status union all
|
35
|
+
select 1 as status union all
|
36
36
|
|
37
|
-
select 2 status union all
|
37
|
+
select 2 as status union all
|
38
38
|
|
39
39
|
・・・
|
40
40
|
|
41
|
-
select 20 status
|
41
|
+
select as 20 status
|
42
42
|
|
43
43
|
) b
|
44
44
|
|
45
45
|
cross join (
|
46
46
|
|
47
|
-
select 1 create_add union all
|
47
|
+
select 1 as create_add union all
|
48
48
|
|
49
|
-
select 2 create_add union all
|
49
|
+
select 2 as create_add union all
|
50
50
|
|
51
51
|
・・・
|
52
52
|
|
53
|
-
select 20 create_add
|
53
|
+
select 20 as create_add
|
54
54
|
|
55
55
|
) c
|
56
56
|
|
57
57
|
cross join (
|
58
58
|
|
59
|
-
select 1 creator union all
|
59
|
+
select 1 as creator union all
|
60
60
|
|
61
|
-
select 2 creator union all
|
61
|
+
select 2 as creator union all
|
62
62
|
|
63
63
|
・・・
|
64
64
|
|
65
|
-
select 10 creator
|
65
|
+
select 10 as creator
|
66
66
|
|
67
67
|
) d
|
68
68
|
|
1
誤字の修正
test
CHANGED
@@ -1,6 +1,6 @@
|
|
1
1
|
idがPKの場合、下記の形はいかがでしょうか。
|
2
2
|
|
3
|
-
それぞれのカラム分の疑似テーブルを作成し、cross joinした
|
3
|
+
それぞれのカラム分の疑似テーブルを作成し、cross joinした結果(25☓20☓20☓10=100,000件)をInsertしています。
|
4
4
|
|
5
5
|
```SQL
|
6
6
|
|