需求:根据不同的 time 去更新 zt的值
update table_name a set a.zt=
case
when a.end_time<=time then '2'
when a.start_time<time and a.end_time>=time then '1'
when a.start_time>time then '0'
end
where a.start_time>time-10
需求:根据不同的 time 去更新 zt的值
update table_name a set a.zt=
case
when a.end_time<=time then '2'
when a.start_time<time and a.end_time>=time then '1'
when a.start_time>time then '0'
end
where a.start_time>time-10