回答編集履歴
1
回答を修正
answer
CHANGED
|
@@ -1,13 +1,21 @@
|
|
|
1
1
|
```sql
|
|
2
2
|
CREATE TABLE hoge_20160603 LIKE hoge;
|
|
3
|
+
INSERT INTO hoge_20160603 SELECT * FROM hoge WHERE date < '2016-06-04 00:00:00'
|
|
3
4
|
```
|
|
4
5
|
を
|
|
5
6
|
```sql
|
|
6
|
-
SET @
|
|
7
|
+
SET @table_name = CONCAT('hoge_', DATE_FORMAT(SUBDATE(CURDATE(), 1), '%Y%m%d'));
|
|
7
8
|
|
|
9
|
+
SET @query = CONCAT('CREATE TABLE ', @table_name, ' LIKE hoge');
|
|
8
10
|
PREPARE stmt FROM @query;
|
|
9
11
|
EXECUTE stmt;
|
|
10
12
|
DEALLOCATE PREPARE stmt;
|
|
13
|
+
|
|
14
|
+
SET @query = CONCAT('INSERT INTO ', @table_name, " SELECT * FROM hoge WHERE date < '2016-06-04 00:00:00'");
|
|
15
|
+
PREPARE stmt FROM @query;
|
|
16
|
+
EXECUTE stmt;
|
|
17
|
+
DEALLOCATE PREPARE stmt;
|
|
18
|
+
|
|
11
19
|
```
|
|
12
20
|
に置き換えてみてください。
|
|
13
21
|
|