mysql计算工作日
-- 建表 CREATE TABLE workdays ( date DATE PRIMARY KEY, is_workday BOOLEAN ); -- 插入数据 INSERT INTO workdays (date, is_workday) VALUES ('2022-01-01', false), ('2022-01-02', false), ('2022-01-03', true), ('2022-01-04', true), ... ('2022-12-31',false); -- 计算两个日期之间的工作日数 SELECT COUNT(*) FROM workdays WHERE date >= '2022-01-01' AND date
