- 方法一
set @num = 0;
select @num:=@num+1 as num,temp.* from jj_product_info as temp;
- 方法二
select (@i:=@i+1) as i,a.* from jj_product_info as a,(select @i:=0) as it
set @num = 0;
select @num:=@num+1 as num,temp.* from jj_product_info as temp;
select (@i:=@i+1) as i,a.* from jj_product_info as a,(select @i:=0) as it