UPDATE game_score SET
score=
(CASE name
WHEN 'player1' THEN score+50
WHEN 'player2' THEN score+47
END)
WHERE name IN
('player1',
'player2')score+50和score+47会出现语法错误,如果我使用WHEN 'player1' THEN '50'或WHEN 'player2' THEN '47',它就会正常工作。但我需要增加分值。
发布于 2017-03-15 07:52:19
你为什么不这样做:
UPDATE game_score SET
score= score +
(CASE name
WHEN 'player1' THEN 50
WHEN 'player2' THEN 47
END)
WHERE name IN
('player1',
'player2')https://stackoverflow.com/questions/42798666
复制相似问题