mysql给查询加序号

SELECT * FROM student;

　

 

SELECT `name`,`subject`,`score`,(@i:=@i+1) AS '序号'  FROM student,(SELECT @i:=0) AS itable;