mysql rownum
SET @rownum:= 0;select @rownum:=@rownum+1 as rownum, t.* from test_staging2_prp3.TM_PROLRECEIPT t