mysql统计玩家昨日最大连赢局数

CREATE DEFINER=`root`@`%` PROCEDURE `pr_backstate_count_user_tax_message`(
in $user_id int,
in $yestoday_start int,
in $yestoday_end int
)
BEGIN	
			
			declare _continnue_win int default 0;
			set @num = 0;
			select max(nums) into _continnue_win from 
			(select if(win_flow > 0, @num := @num + 1,@num := 0) nums 
			from player_paiju_log_tbl
			where user_id = $user_id and update_time >= $yestoday_start
			and update_time < $yestoday_end) temp_tbl;
			
			
END