as

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

语法

as

参数

参数名参数类型描述是否必填
cs_namestring集合空间名。否
cl_namestring集合名。否
select_setset查询结果集。否
field_namestring字段名。否
alias_namestring别名。是

示例

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

    1. { "name": "Lucy", "age": 11 }
    2. { "name": "Sam", "age": 8 }
    3. { "name": "Tom", "age": 7 }
    4. { "name": "James", "age": 12 }

  • 集合别名。

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

  • 字段别名。

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

  • 结果集别名。

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