回答編集履歴
1
chousei
answer
CHANGED
|
@@ -16,9 +16,12 @@
|
|
|
16
16
|
/* 予め想定される100年分くらいのデータを入れておく*/
|
|
17
17
|
create table all_month(ymd varchar(6) primary key);
|
|
18
18
|
insert into all_month values
|
|
19
|
-
('201701'),('201702'),('201703'),('201704'),('201705'),('201706'),
|
|
19
|
+
('201701'),('201702'),('201703'),('201704'),('201705'),('201706'),
|
|
20
|
+
('201707'),('201708'),('201709'),('201710'),('201711'),('201712'),
|
|
20
|
-
('201801'),('201802'),('201803'),('201804'),('201805'),('201806'),
|
|
21
|
+
('201801'),('201802'),('201803'),('201804'),('201805'),('201806'),
|
|
22
|
+
('201807'),('201808'),('201809'),('201810'),('201811'),('201812'),
|
|
21
|
-
('201901'),('201902'),('201903'),('201904'),('201905'),('201906'),
|
|
23
|
+
('201901'),('201902'),('201903'),('201904'),('201905'),('201906'),
|
|
24
|
+
('201907'),('201908'),('201909'),('201910'),('201911'),('201912');
|
|
22
25
|
```
|
|
23
26
|
|
|
24
27
|
- 検索
|