这个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)
