为什么这个查询不起作用? :( 我尝试替换嵌套 IF 语句“...SET key = IF(key >= 11, key - 5, IF(lkey > 5, lkey + 2,lkey))”
UPDATE pages
SET lkey = CASE lkey WHEN lkey >= 11 THEN
lkey - 5
ELSE
CASE lkey WHEN lkey > 5 THEN
lkey + 2
ELSE
lkey
END
END,
rkey = CASE lkey WHEN lkey >= 11 THEN
rkey - 5
ELSE
CASE rkey WHEN rkey < 11 THEN
rkey + 2
ELSE
rkey
END
END
WHERE rkey > 5 AND
lkey < 12;
该子句(以及类似子句)中的语法错误
CASE lkey WHEN lkey > 5 THEN
lkey + 2
ELSE
lkey
END
要么是
CASE WHEN [condition] THEN [expression] ELSE [expression] END
or
CASE [expression] WHEN [value] THEN [expression] ELSE [expression] END
所以在你的情况下它会显示:
CASE WHEN lkey > 5 THEN
lkey + 2
ELSE
lkey
END
查看文档(CASE 表达式):
http://www.sqlite.org/lang_expr.html http://www.sqlite.org/lang_expr.html
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)