mysql数据库-索引、字段别名、表别名
1.设置字段别名
SELECT filed1,filed2 FROM tbname;
SELECT filed1 AS a,filed2 AS b FROM tbname;//修改字段别名(Alias-AS)
2.设置表别名
select t.filed1,t.filed2,t.filed3 from tbname as t; //(as可以省略)
select t.filed1,t.filed2,t.filed3 from tbname t; //(as可以省略)