1.SELECT (@i:=@i+1) AS num,xo.NAME_ name FROM tableName yv ,(SELECT @i:=0) AS it
2. SELECT @rownum:=@rownum+1 rownum, t.* From
(SELECT @rownum:=0,m.* FROM hehe m) t;
1.SELECT (@i:=@i+1) AS num,xo.NAME_ name FROM tableName yv ,(SELECT @i:=0) AS it
2. SELECT @rownum:=@rownum+1 rownum, t.* From
(SELECT @rownum:=0,m.* FROM hehe m) t;