回答編集履歴
1
chousei
test
CHANGED
|
@@ -18,3 +18,13 @@
|
|
|
18
18
|
left join tbl t2 on t1.dt between t2.start_time and t2.end_time
|
|
19
19
|
order by dt;
|
|
20
20
|
```
|
|
21
|
+
もしかしたらこうかも
|
|
22
|
+
```SQL
|
|
23
|
+
select t1.dt,case when t2.reserve_no is null then '-' else '▲' end as reserve from (
|
|
24
|
+
SELECT (select @a := @a + interval 15 minute from (select @a:='2022-03-14 10:45') as dummy) AS dt
|
|
25
|
+
FROM information_schema.COLUMNS
|
|
26
|
+
LIMIT 49) as t1
|
|
27
|
+
left join tbl t2 on t1.dt between t2.start_time and t2.end_time
|
|
28
|
+
or t1.dt + interval 15 minute between t2.start_time and t2.end_time
|
|
29
|
+
order by dt;
|
|
30
|
+
```
|