MySQL中select column1 column2 from（列取别名）

在MySQL编程中遇到select column1  column2 from这种用法，其中column1  column2之间为空格，不是逗号，不明白其中的语法，通过查找资料得知可能是以下语法的形式：

                         select column1 as column2 from

省略其中as得到：

                       select column1  column2 from

验证：

1.

mysql> select hight name from xzq;

+------+
| name |
+------+
|   13 |
|   14 |
|   15 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    0 |
|    0 |
|    0 |
| NULL |
| NULL |
| NULL |
+------+
36 rows in set (0.00 sec)

2.

mysql> select hight as name from xzq;

+------+
| name |
+------+
|   13 |
|   14 |
|   15 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    4 |
|    5 |
|    6 |
|    0 |
|    0 |
|    0 |
| NULL |
| NULL |
| NULL |
+------+
36 rows in set (0.00 sec)

结果：select column1  column2 from为 select column1 as column2 from的省略形式。