mysql ---as取别名

#2 AS 给列取别名，也可以给表取。AS可以不写，写上去规范一点
AS，只会改变标题，不会改变表结构

select ano as ‘学号’ ，sname as ‘姓名’,age as ‘年龄’,sex from student as s where s.age=50

select scode as 学员编号, sname as 学员姓名, saddress as 学员地址 from students;