mysql查询创建序号的方式
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;
版权声明：本文为mayapinggo原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
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;