回答編集履歴
1
ちょうせい
test
CHANGED
@@ -1,2 +1,15 @@
|
|
1
1
|
2022-04-30 23:50から4分間隔で最小値を選ぶなら
|
2
2
|
2022-04-30 23:50:01 284201が対象では?
|
3
|
+
|
4
|
+
こんな感じのダミーテーブル処理が有効だと思います
|
5
|
+
```SQL
|
6
|
+
select * from (
|
7
|
+
SELECT @dt := '2022-04-30 23:50' AS start,
|
8
|
+
@dt +interval 239 second AS end
|
9
|
+
UNION
|
10
|
+
SELECT @dt := @dt + interval 4 minute,
|
11
|
+
@dt +interval 239 second AS start
|
12
|
+
FROM information_schema.COLUMNS
|
13
|
+
WHERE @dt<='2022-05-02 00:20'
|
14
|
+
) as t1
|
15
|
+
```
|