mysql中怎么解决关于ROW mysql 怎么实现row

mysql中怎么解决关于ROW

MySQL要用变量如：
set @row=0

select
*
from
(
select (@row:=@row 1) as RowNum,* from 表--这里加排序用Order by
)as A

SQL Server --Row_Number
Oracle--Row_number/rownum

mysql 怎么实现row

要用变量如：
set @row=0
select
*
from
(
select (@row:=@row 1) as RowNum,* from 表--这里加排序用Order by
)as A
SQL Server --Row_Number
Oracle--Row_number/rownum