as

用于为集合名、字段名或结果集指定别名（alias）。

语法

<cs_name.cl_name | (select_set) | field_name> as <alias_name>

参数

示例

• 集合 foo.bar 中存在如下记录。

  { "name": "Lucy", "age": 11 }
  { "name": "Sam", "age": 8 }
  { "name": "Tom", "age": 7 }
  { "name": "James", "age": 12 }

• 集合别名。

  > db.exec("select T1.age, T1.name from foo.bar as T1 where T1.age>10")
  { "name": "Lucy", "age": 11 }
  { "name": "James", "age": 12 }
  Return 2 row(s).
  Takes 0.6149s.

• 字段别名。

  > db.exec("select age as 年龄 from foo.bar where age>10")
  { "年龄": 11 }
  { "年龄": 12 }
  Return 2 row(s).
  Takes 0.2981s.

• 结果集别名。

  > db.exec("select T.age, T.name from (select age, name from foo.bar) as T where T.age>10")
  { "name": "Lucy", "age": 11 }
  { "name": "James", "age": 12 }
  Return 2 row(s).
  Takes 0.3920s.