現(xiàn)在有兩張表一張用于存儲時間片段的duration表CREATE TABLE `duration` ( `id` int(0) NOT NULL, `start_time` datetime(0) NULL, `end_time` datetime(0) NULL,
);一張用于存儲數(shù)據(jù)的data表，有數(shù)據(jù)的插入時間CREATE TABLE `data` ( `id` int(0) NOT NULL, `record_time` datetime(0) NULL,
);這倆表id都是可以重復的現(xiàn)在從duration表中查出多條數(shù)據(jù)，也就是獲取到了多個時間片段，然后再data表中查出對應(yīng)record_time在之前查出的多個時間片段之間的數(shù)據(jù)。大佬們這個咋弄？
1 回答
慕神8447489
TA貢獻1780條經(jīng)驗 獲得超1個贊
insert into duration (id, start_time, end_time) values(1, '2018-1-1', '2018-1-10'), (2, '2018-2-1', '2018-2-10'), (3, '2018-3-1', '2018-3-10'); insert into data (id, record_time) values(1, '2018-1-2'), (2, '2018-2-2'), (3, '2018-3-2'), (4, '2018-4-2'), (5, '2018-1-12'); select data.* from data, duration where record_time between start_time and end_time ;
結(jié)果會是:
'1', '2018-01-02 00:00:00''2', '2018-02-02 00:00:00''3', '2018-03-02 00:00:00'
添加回答
舉報
0/150
提交
取消