MySQL - Get a Max value from Column, then store in variable
<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>