关于#mysql#的问题，如何解决？

Question

MySQL根据当前系统时间now()，判断季节,1-3为春季，4-6为夏季，7-9为秋季，10-12为冬季，并将结果存入变量season中

Answer 1

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;