SQL之取别名

SELECT * FROM 表名 [AS] 表的别名 WHERE .... ;

select * from student as stu;

SELECT 字段名1 [AS] 别名1 , 字段名2 [AS] 别名2 , ... FROM 表名 WHERE ... ;

select name as '姓名',id from student;