mysql - 如何从查询中选择第一行到 MySQL 中的过程变量

Question

DECLARE topScorer INT default 0;

SELECT id INTO topScorer FROM game_player
WHERE game_player.score = (SELECT max(score) FROM game_player)

一个不好的例子，但很容易由天真的编码产生...如果返回多行，它在我的测试中不起作用，我如何才能将第一个返回的行放入变量中？

Answer 1

您只需要一个分数吗？

SELECT id 
  INTO topScorer 
  FROM game_player
 WHERE game_player.score = (   SELECT max(score) as maxScore 
                                 FROM game_player 
                                 ) LIMIT 1

更新:Rufo 爵士是对的，上面的代码现已更正。