title: MySQL - Get a Max value from Column, then store in variable
body: <p>I'm trying to grab the maximum ID number for a person, increment it by one, and store in a variable. I've been getting NULL until I initialized the variable to 0. Now i'm just getting 0. Could you help me out?</p>
  
  <pre><code>--Initialize @Var (probably unnecessary)
  SET @Var = 0;
  
  -- Increment Max Value by 1, store in @Var
  Select @Var = (MAX(Person_ID) + 1) From Person;
  
  --prints out the value 0????
  Select @Var 
  </code></pre>