SELECT * FROM student;
SELECT `name`,`subject`,`score`,(@i:=@i+1) AS '序号' FROM student,(SELECT @i:=0) AS itable;
标签:name,查询,student,mysql,序号,SELECT From: https://www.cnblogs.com/boye169/p/17339190.html
SELECT * FROM student;
SELECT `name`,`subject`,`score`,(@i:=@i+1) AS '序号' FROM student,(SELECT @i:=0) AS itable;
标签:name,查询,student,mysql,序号,SELECT From: https://www.cnblogs.com/boye169/p/17339190.html