mysql中如何添加序号，让其自动增加序号

1. 少废话，直接上代码

SELECT (@i:=@i+1) i,user_id,user_name FROM dt_user_all_orders, (SELECT @i:=0) as i