title: How to select the first row from a query into a procedure-variable in MySQL
body: <pre><code>DECLARE topScorer INT default 0;
  
  SELECT id INTO topScorer FROM game_player
  WHERE game_player.score = (SELECT max(score) FROM game_player)
  </code></pre>
  
  <p>A bad example but one that could easily result from naive coding... it doesn't work in my testing if multiple rows are returned, how can I get the first returned row into the variable?</p>