SELECT @rowNum := @rowNum+1 AS rownum,u.id FROM sys_user u,(SELECT @rowNum:=0) r
MySQL给查出来的数据加序号
最新推荐文章于 2024-08-06 04:31:03 发布
SELECT @rowNum := @rowNum+1 AS rownum,u.id FROM sys_user u,(SELECT @rowNum:=0) r