Neo4j查询电影数据库不在查询Neo4j - NOT IN query
MATCH (actor:Actor {name:"Tom Hanks"} )-[:ACTED_IN]->(movies)<-[:ACTED_IN]-(coactor)
WITH collect(distinct coactor) as coactors
MATCH (actor:Actor)
WHERE actor NOT IN coactors
RETURN actor
运行此查询时出现错误:
输入'N'无效:预期的空格,注释,节点标签,MapLiteral,参数,关系模式,'(',' . ','[',“=〜”,IN,STARTS,ENDS,CONTAINS,IS, '^','*','/','%','',' - ','=',“<>”,“!=”,'<','>',“<=”, “> =”,AND,XOR,OR,LOAD CSV,START,MATCH,UNWIND,MERGE,CREATE,SET,DELETE,REMOVE,FOREACH,WITH,RETURN,UNION,';'或输入结束(第4行,列13(偏移:160))“哪里演员不在同一个人”
2 回答
我相信他们的示例查询中存在一个小错误 .
是不正确的语法(虽然我不介意Cypher更新允许它) . 它应该是
InverseFalcon有正确的答案,但请注意,解析器会告诉您错误的确切位置:第4行,第13列 .
它还告诉您在该点可以预期的内容(包括
IN
),并且不包括NOT
.