说明：

　　SQLite 的别名 是指可以暂时把表或列重命名为另一个名字。
　　注意：使用表别名是指在一个特定的 SQLite 语句中重命名表。
　　重命名是临时的改变，在数据库中实际的表的名称不会改变。

　　假设有如下表student：

sqlite> select  * from student;
ID          NAME        AGE         ADDRESS
----------  ----------  ----------  ----------
1           xiaoming    18          shenzhen
2           xiaohua     18          beijing
3           mingming    19          shanghai
4           xiaogang    20          hangzhou
5           honghong    17          shenzhen
6           liangliang  21          wuhan
7           tingting    23          shenzhen

　　和表region：

sqlite> select  * from region;
ID          ADDRESS
----------  ----------
1           shenzhen
2           beijing
3           shanghai
sqlite>

给表取别名语法：

SELECT column1, column2....
FROM table_name AS table_alias_name
WHERE [condition];

给列取别名语法：

SELECT column_name AS column_alias_name
FROM table_name
WHERE [condition];

列取别名实例：

sqlite> select NAME as My_Name, ADDRESS as My_Address from student;
My_Name     My_Address
----------  ----------
xiaoming    shenzhen
xiaohua     beijing
mingming    shanghai
xiaogang    hangzhou
honghong    shenzhen
liangliang  wuhan
tingting    shenzhen
sqlite>

表取别名实例：

sqlite>select S.ID , R.ADDRESS from student as S, region as R where S.ADDRESS=R.ADDRESS;
ID          ADDRESS
----------  ----------
1           shenzhen
5           shenzhen
7           shenzhen
2           beijing
3           shanghai