質問編集履歴
2
INSERT文の追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -104,7 +104,25 @@
|
|
|
104
104
|
|
|
105
105
|
PRIMARY KEY (`MONTH`,`DAY`,`ID`)
|
|
106
106
|
|
|
107
|
-
)
|
|
107
|
+
) ;
|
|
108
|
+
|
|
109
|
+
INSERT INTO `TABLE1` VALUES
|
|
110
|
+
|
|
111
|
+
(1,1,'A',100),
|
|
112
|
+
|
|
113
|
+
(1,1,'B',101),
|
|
114
|
+
|
|
115
|
+
(1,2,'A',102),
|
|
116
|
+
|
|
117
|
+
(1,2,'B',103),
|
|
118
|
+
|
|
119
|
+
(2,1,'A',104),
|
|
120
|
+
|
|
121
|
+
(2,1,'B',105),
|
|
122
|
+
|
|
123
|
+
(2,2,'A',106),
|
|
124
|
+
|
|
125
|
+
(2,2,'B',107);
|
|
108
126
|
|
|
109
127
|
```
|
|
110
128
|
|
|
@@ -118,7 +136,15 @@
|
|
|
118
136
|
|
|
119
137
|
PRIMARY KEY (`ID`)
|
|
120
138
|
|
|
121
|
-
)
|
|
139
|
+
) ;
|
|
140
|
+
|
|
141
|
+
INSERT INTO `TABLE2` VALUES
|
|
142
|
+
|
|
143
|
+
('A','001'),
|
|
144
|
+
|
|
145
|
+
('B','002'),
|
|
146
|
+
|
|
147
|
+
('C','003');
|
|
122
148
|
|
|
123
149
|
```
|
|
124
150
|
|
1
テーブルのCREATE文を追記
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -88,7 +88,39 @@
|
|
|
88
88
|
|
|
89
89
|
MySQLを用いています。
|
|
90
90
|
|
|
91
|
+
TABLE1, TABLE2 は下記でCREATEしています。
|
|
91
92
|
|
|
93
|
+
```SQL
|
|
94
|
+
|
|
95
|
+
CREATE TABLE `TABLE1` (
|
|
96
|
+
|
|
97
|
+
`MONTH` int(2) NOT NULL,
|
|
98
|
+
|
|
99
|
+
`DAY` int(2) NOT NULL,
|
|
100
|
+
|
|
101
|
+
`ID` char(4) NOT NULL,
|
|
102
|
+
|
|
103
|
+
`DATA` int(4) DEFAULT NULL,
|
|
104
|
+
|
|
105
|
+
PRIMARY KEY (`MONTH`,`DAY`,`ID`)
|
|
106
|
+
|
|
107
|
+
)
|
|
108
|
+
|
|
109
|
+
```
|
|
110
|
+
|
|
111
|
+
```SQL
|
|
112
|
+
|
|
113
|
+
CREATE TABLE `TABLE2` (
|
|
114
|
+
|
|
115
|
+
`ID` char(4) NOT NULL,
|
|
116
|
+
|
|
117
|
+
`NAME` char(4) DEFAULT NULL,
|
|
118
|
+
|
|
119
|
+
PRIMARY KEY (`ID`)
|
|
120
|
+
|
|
121
|
+
)
|
|
122
|
+
|
|
123
|
+
```
|
|
92
124
|
|
|
93
125
|
###試したこと
|
|
94
126
|
|