select s.* from student s order by s.name;
mysql目前不支持rownum功能,如果想按某字段进行排序,然后得到排序号,可以如下:
select (@rowNum:=@rowNum+1) rowNum, s.*
from student s, (select (@rowNum :=0) ) rn
order by s.name;
select s.* from student s order by s.name;
mysql目前不支持rownum功能,如果想按某字段进行排序,然后得到排序号,可以如下:
select (@rowNum:=@rowNum+1) rowNum, s.*
from student s, (select (@rowNum :=0) ) rn
order by s.name;