mysql判断时间段是否重合
SELECT CASE WHEN t1.start_time <= t2.end_time AND t1.end_time >= t2.start_time THEN ‘重合’ ELSE ‘不重合’ END AS result
FROM table_name t1, table_name t2
WHERE t1.id <> t2.id;
mysql判断时间段是否重合
SELECT CASE WHEN t1.start_time <= t2.end_time AND t1.end_time >= t2.start_time THEN ‘重合’ ELSE ‘不重合’ END AS result
FROM table_name t1, table_name t2
WHERE t1.id <> t2.id;