SELECT @rownum:=@rownum+1 AS rownum,hyd_day_loandetil.* FROM (SELECT @rownum:=0) r, hyd_day_loandetil;
rownum变量名;hyd_day_loandetil 查询的表名
SELECT @rownum:=@rownum+1 AS rownum,hyd_day_loandetil.* FROM (SELECT @rownum:=0) r, hyd_day_loandetil;
rownum变量名;hyd_day_loandetil 查询的表名