As是将请求的结果以别名方式展示并返回。

示例

select count(*) as countRow from test;
select c1 as testC from test where c1 = '2';