SELECT count(*)  INTO @num FROM mytable; 
SELECT @num;