有没有办法像oracle中的rownum一样获取Mysql中的行号,如果没有,那么有没有间接的方法呢?请提出建议.
Is there a way to get the row number in Mysql like the rownum in oracle, If not then is there any indirect way of doing it? please suggest.
直到 MySQL 最终支持现代 SQL,唯一的办法得到类似的东西是这样的:
Until MySQL finally supports modern SQL, the only way to get something similar is this:
SELECT @rownum:=@rownum + 1 as row_number,
t.*
FROM (
< your original query goes here >
) t,
(SELECT @rownum := 0) r
这篇关于有没有办法像oracle中的rownum一样获取Mysql中的行号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!