update jtl_2005 set sj_width=(case sj
when between '00:00:00 ' and '00:14:59 ' then '1 '
when between '00:15:00 'and '00:29:59 ' then '2 '
end)
------解决方案--------------------
try
update jtl_2005 set sj_width=(case when sj between '00:00:00 ' and '00:14:59 ' then '1 '
when sj between '00:15:00 'and '00:29:59 ' then '2 '
end)
------解决方案--------------------
update jtl_2005 set sj_width=(case sj
when between '00:00:00 ' and '00:14:59 ' then '1 '
when between '00:15:00 'and '00:29:59 ' then '2 '
--else没有加
else null
end)
------解决方案--------------------
update jtl_2005 set sj_width=
case when sj between '00:00:00 ' and '00:14:59 ' then '1 '
when sj between '00:15:00 'and '00:29:59 ' then '2 '
end
------解决方案--------------------
update jtl_2005 set sj_width=(case when sj between '00:00:00 ' and '00:14:59 ' then '1 '
when sj between '00:15:00 'and '00:29:59 ' then '2 '
end)
when 后面少了条件
------解决方案--------------------
update jtl_2005 set sj_width=(case sj
when between '00:00:00 ' and '00:14:59 ' then '1 '
when between '00:15:00 'and '00:29:59 ' then '2 '
end)
where 条件
------解决方案--------------------
不過可以加上個else
update jtl_2005 set sj_width=
(case when sj between '00:00:00 ' and '00:14:59 ' then '1 '
when sj between '00:15:00 'and '00:29:59 ' then '2 '
Else Null
end)