Mysql 给表或者字段起别名

1. 给表起别名:

select * from student_info a where a.sno = '001';

或者

select * from student_info as a where a.sno = '002';

 

2.给字段起别名:

select name,school sc,address ad from student_info a where a.sno = '001';

或者

select name,school as sc,address as ad from student_info a where a.sno = '002';