mysql 计算两个日期之间的工作日天数

2019独角兽企业重金招聘Python工程师标准>>>

创建透视表t500

建表

CREATE TABLE `t500` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=latin1;

插入500条数据

CREATE DEFINER=`json`@`%` PROCEDURE `i500`()
BEGIN 
 DECLARE a INT default 1;
 while a<=500 do
 insert into t500 (id) value(a);
 set a=a+1;
 end while;
 end

2.1

select t500.id from t500 where t500.id <=DATEDIFF("2019-02-01