1、基本查询
查询单条记录:
RETURN DOCUMENT("users/9883")
同时查询多条记录:
RETURN DOCUMENT( ["users/9883", "users/9915", "users/10074"] )
查询所有记录:
FOR user IN users
RETURN user
按某个字段排序返回查询结果:
FOR user IN users
SORT user.age [ASC|DESC]
RETURN user
条件查询:
FOR user IN users
FILTER user.age > 30 SORT user.age
RETURN user
查询只返回部分字段:
FOR user IN users
RETURN { userName: user.name, age: user.age }
更新:
UPDATE "9915" WITH { age: 40 } IN users
RETURN NEW
插入:
INSERT { name: "Katie Foster", age: 27 } INTO users
删除单条记录:
REMOVE "9883" IN users
根据条件删除记录:
FOR user IN users
FILTER user.age >= 30 REMOVE user IN users