这个UPDATE 语句为什么错!急...
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)