現(xiàn)在有兩張表一張用于存儲(chǔ)時(shí)間片段的duration表CREATE TABLE `duration` ( `id` int(0) NOT NULL, `start_time` datetime(0) NULL, `end_time` datetime(0) NULL,
);一張用于存儲(chǔ)數(shù)據(jù)的data表，有數(shù)據(jù)的插入時(shí)間CREATE TABLE `data` ( `id` int(0) NOT NULL, `record_time` datetime(0) NULL,
);這倆表id都是可以重復(fù)的現(xiàn)在從duration表中查出多條數(shù)據(jù)，也就是獲取到了多個(gè)時(shí)間片段，然后再data表中查出對(duì)應(yīng)record_time在之前查出的多個(gè)時(shí)間片段之間的數(shù)據(jù)。大佬們這個(gè)咋弄？
1 回答
慕神8447489
TA貢獻(xiàn)1780條經(jīng)驗(yàn) 獲得超1個(gè)贊
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é)果會(huì)是:
'1', '2018-01-02 00:00:00''2', '2018-02-02 00:00:00''3', '2018-03-02 00:00:00'
添加回答
舉報(bào)
0/150
提交
取消