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;