mysql自带函数dayofweek,和中国的星期对不上 周一到周六:2~7 周七:1 select if(dayofweek(curdate()) = 1,7,dayofweek(curdate()) -1);