SELECT (@i:=@i+1) i,user_id,user_name FROM dt_user_all_orders
, (SELECT @i:=0) as i
转载于:https://www.cnblogs.com/hcfan/p/11137266.html
SELECT (@i:=@i+1) i,user_id,user_name FROM dt_user_all_orders
, (SELECT @i:=0) as i
转载于:https://www.cnblogs.com/hcfan/p/11137266.html