回答編集履歴
2
追記
test
CHANGED
@@ -3,3 +3,7 @@
|
|
3
3
|
INSERT INTO B SELECT `column_name` FROM A WHERE id = 1000;
|
4
4
|
|
5
5
|
```
|
6
|
+
|
7
|
+
|
8
|
+
|
9
|
+
WHERE 以下は通常の条件式と同じ。
|
1
修正
test
CHANGED
@@ -1,5 +1,5 @@
|
|
1
1
|
```sql
|
2
2
|
|
3
|
-
INSERT INTO
|
3
|
+
INSERT INTO B SELECT `column_name` FROM A WHERE id = 1000;
|
4
4
|
|
5
5
|
```
|