MySQL根据当前系统时间now(),判断季节,1-3为春季,4-6为夏季,7-9为秋季,10-12为冬季,并将结果存入变量season中
set @season := case
when month(now()) between 1 and 3 then '春季'
when month(now()) between 4 and 6 then '夏季'
when month(now()) between 7 and 9 then '秋季'
when month(now()) between 10 and 12 then '冬季' end;