SQL语句中的as

一、正常的SQL

SELECT id, name, age from student;

二、查询出的结果展示前修改为同一类值

SELECT id, 'xuesheng' as name ,age FROM student;

三、列名别名

SELECT id  as  "SID", name, age FROM student;