1.mysql获取序列(相较于orcale的rownum)
select
@rownum := @rownum + 1 AS rank,
user.*
from
( select@rownum := 0 ) r,
user;
数据库端
最新推荐文章于 2024-09-13 22:38:14 发布
1.mysql获取序列(相较于orcale的rownum)
select
@rownum := @rownum + 1 AS rank,
user.*
from
( select@rownum := 0 ) r,
user;