#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;
#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;