mysql 视图中不能使用变量,怎么添加序号

1、首先创建一个视图

create or REPLACE VIEW t_5gnumber_views as select * from t_5gnumber;

2、接着检查创建的视图是否可用

3、然后套用固定格式，语句如下可以是视图或者表或者子查询 

Select (@i:=@i+1) as RowNum, A.* from "视图或者表或者子查询" A,(Select @i:=0) B;

4、以视图为例

Select (@i:=@i+1) as RowNum, A.* from t_5gnumber_views A,(Select @i:=0) B;

5、以表为例

Select (@i:=@i+1) as RowNum, A.* from t_5gnumber A,(Select @i:=0) B;

6、以子查询为例

Select (@i:=@i+1) as RowNum, A.* from (select * from t_5gnumber) A,(Select @i:=0) B;