更新分数时 MySQL 语法错误

Question

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' 则有效>。但我需要添加分数值。

Answer 1

你为什么不这样做:

UPDATE game_score SET 
    score= score + 
        (CASE name 
         WHEN 'player1' THEN 50 
         WHEN 'player2' THEN 47 
    END)
WHERE name IN 
('player1', 
 'player2')