A-LIKES->B,A-LIKES->C,B-LIKES->C<\/strong>\u306e\u3088\u3046\u306a\u8ad6\u7406\u3092 CREATE (:Person { name: \u2019Dan\u2019 })-[:MARRIED { day:\u20191970-02-14 } ]->(:Person { name : \u2019 Ann\u2019)<\/p>\n \u30b0\u30e9\u30d5\u30e2\u30c7\u30eb\u306f\u9802\u70b9\u3068\u8fba\u306b\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6301\u305f\u305b\u308b\u3001\u3068\u3066\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u69cb\u9020\u3067\u30c7\u30fc\u30bf\u3092\u8868\u73fe\u3057\u307e\u3059\u3002<\/p>\n \u30ce\u30fc\u30c9\u3068\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306f\u3069\u3061\u3089\u3082\u30ad\u30fc\u30d0\u30ea\u30e5\u30fc\u30bf\u30a4\u30d7\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6301\u3064\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n (:Person {{key1:value1, key2:value2, \u2026} }<\/strong> \u3053\u306e\u3088\u3046\u306a\u30b0\u30e9\u30d5\u3092\u30d7\u30ed\u30d1\u30c6\u30a3\u30b0\u30e9\u30d5\u3068\u547c\u3073\u307e\u3059\u3002<\/p>\n \u3053\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306e\u7279\u5fb4\u306e\u305f\u3081\u306b\u3001\u3068\u3066\u3082\u8907\u96d1\u306a\u7e4b\u304c\u308a\u3092\u3082\u3064\u4e8b\u8c61\u3067\u3082\u7c21\u5358\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u8a08\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n \u6b21\u306f\u3001\u300c\u30d1\u30ca\u30de\u6587\u66f8\u300d\u306e\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u3067\u3059\u3002 Displaying 4 nodes, 322 relationships Neo4j\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u3001\u6b21\u306e\u8a18\u4e8b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n Windows\u3067Neo4j\u3092\u4f7f\u3063\u3066\u307f\u308b<\/a><\/p>\n Azure\u3067Neo4j\u3092\u4f7f\u3063\u3066\u307f\u308b<\/a><\/p>\n \u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001Neo4j\u304c\u63d0\u4f9b\u3057\u3066\u3044\u308b\u30e0\u30fc\u30d3\u30fc\u30b0\u30e9\u30d5\u3092\u5229\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n () \u3000 born: 1970\u3092\u30d5\u30a3\u30eb\u30bf\u30fc\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n ()--() ACTED_IN\u3092\u30d5\u30a3\u30eb\u30bf\u30fc\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n type()\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u30bf\u30a4\u30d7\u3092\u51fa\u529b\u3057\u307e\u3059\u3002<\/p>\n \u300c\u8b58\u5225\u5b50.\u30ad\u30fc\u300d\u306e\u3088\u3046\u306b\u51fa\u529b\u3057\u307e\u3059\u3002<\/p>\n \u3000\u3000\/\/ hogehoge \u2003<\/p>\n \u3053\u308c\u306fCypher\u30cd\u30a4\u30c6\u30a3\u30d6\u306e\u69cb\u6587\u3067\u3059\u3002<\/p>\n \u6b21\u306fWHERE\u53e5\u306b\u3088\u308b\u69cb\u6587\u3067\u3059\u3002<\/p>\n \u6b21\u306e2\u3064\u306e\u69cb\u6587\u306f\u540c\u3058\u610f\u5473\u3067\u3059\u3002<\/p>\n m.tagline\u304c\u5b58\u5728\u3059\u308b\u30d1\u30bf\u30fc\u30f3\u3092\u63a2\u7d22\u3057\u307e\u3059\u3002<\/p>\n \u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3063\u3066\u30d5\u30a3\u30eb\u30bf\u30fc\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059(=~)\u3002<\/p>\n \u8907\u6570\u306e\u30c7\u30fc\u30bf\u3092\u30ea\u30b9\u30c8\u30bf\u30a4\u30d7\u306b\u4e26\u3079\u3066\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n \u5909\u6570\u3068\u3057\u3066\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n ALL\u306f\u30ea\u30b9\u30c8\u306e\u3059\u3079\u3066\u306e\u8981\u7d20\u304c\u6761\u4ef6\u3092\u6e80\u305f\u305b\u3070true\u3068\u306a\u308a\u307e\u3059\u3002\u6b21\u306e\u4f8b\u3067\u306flist1\u304clist2\u306b\u542b\u307e\u308c\u308b\u6642\u306btrue\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n NONE\u306f\u30ea\u30b9\u30c8\u306e\u3059\u3079\u3066\u306e\u8981\u7d20\u304c\u6761\u4ef6\u3092\u6e80\u305f\u3055\u306a\u3044\u6642\u306btrue\u3068\u306a\u308a\u307e\u3059\u3002\u6b21\u306e\u4f8b\u3067\u306flist1\u3068list2\u306b\u5171\u901a\u306e\u8981\u7d20\u304c\u306a\u3044\u6642\u306btrue\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n ANY\u306f\u30ea\u30b9\u30c8\u306e\u4e2d\u30671\u3064\u3067\u3082\u6761\u4ef6\u3092\u6e80\u305f\u3059\u8981\u7d20\u304c\u3042\u308c\u3070true\u3092\u8fd4\u3057\u307e\u3059\u3002list1\u3068list2\u306f1\u3064\u4ee5\u4e0a\u306e\u5171\u901a\u8981\u7d20\u304c\u3042\u308c\u3070true\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n <\/p>\n SINGLE\u306f\u6761\u4ef6\u3092\u6e80\u305f\u3059\u8981\u7d20\u304c1\u3064\u306e\u307f\u306e\u3068\u304d\u306btrue\u3068\u306a\u308a\u307e\u3059\u3002list1\u3068list2\u306e\u5171\u901a\u8981\u7d20\u304c\u3072\u3068\u3064\u3060\u3051\u306e\u3068\u304d\u306btrue\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n <\/p>\n \u6b21\u306e\u69cb\u6587\u3067\u306f\u6620\u753b\u30ea\u30b9\u30c8\u306b\u91cd\u8907\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n DISTINCT\u3092\u4f7f\u3063\u3066\u6620\u753b\u30ea\u30b9\u30c8\u306e\u4e2d\u8eab\u3092\u30e6\u30cb\u30fc\u30af\u306b\u3057\u307e\u3059\u3002<\/p>\n \u6b21\u306e\u69cb\u6587\u306f\u540c\u3058\u7d50\u679c\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n \u6620\u753b\u306e\u30ea\u30ea\u30fc\u30b9\u5e74\u5ea6\u3067\u964d\u9806\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/p>\n \u6620\u753b\u306e\u30ea\u30ea\u30fc\u30b9\u5e74\u5ea6\u3067\u6607\u9806\u30bd\u30fc\u30c8\u3057\u307e\u3059\u3002<\/p>\n \u7d50\u679c\u5024\u3092\u8868\u793a\u3059\u308b\u6570\u3092\u5236\u9650\u3057\u307e\u3059\u3002<\/p>\n \u7d50\u679c\u5024\u3092\u30ea\u30b9\u30c8\u306b\u96c6\u5408\u3057\u307e\u3059\u3002<\/p>\n UNWIND\u306f\u30ea\u30b9\u30c8\u306e\u8981\u7d20\u3092\u53d6\u308a\u51fa\u3057\u307e\u3059\u3002<\/p>\n UNWIND\u306e\u5909\u63db\u5024\u306f\u30af\u30a8\u30ea\u304b\u3089\u5909\u6570\u3068\u3057\u3066\u53c2\u7167\u3067\u304d\u307e\u3059\u3002<\/p>\n \u73fe\u5728\u306e\u5e74\u5ea6\u3068\u4ff3\u512a\u306e\u51fa\u751f\u5e74\u5ea6\u3067\u5e74\u9f62\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/p>\n date()\u51e6\u7406\u3067\u3059\u3002<\/p>\n datetime()\u51e6\u7406\u3067\u3059\u3002<\/p>\n \u7e4b\u304c\u308a\u3092\u6301\u305f\u306a\u3044\u30d1\u30bf\u30fc\u30f3\u3092\u6f0f\u308c\u306a\u304f\u63a2\u7d22\u3059\u308b\u3068\u304d\u306b\u4f7f\u3044\u307e\u3059\u3002<\/p>\n Tom Cruise\u306f3\u672c\u306e\u6620\u753b\u306b\u51fa\u6f14\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n COLLECT\u306f\u7d50\u679c\u5024\u3092\u30ea\u30b9\u30c8\u306b\u4e0e\u3048\u307e\u3059\u3002 Tom Cruise\u3055\u3093\u304c\u51fa\u6f14\u3057\u3066\u3044\u308b\u6620\u753b\u306e\u672c\u6570\u3092\u8a08\u7b97\u3057\u3066\u307f\u307e\u3059\u3002 Cypher\u306f\u96c6\u8a08\u3057\u306a\u304c\u3089\u3001\u305d\u306e\u8981\u7d20\u3092\u30ea\u30b9\u30c8\u306b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n \u96c6\u8a08\u95a2\u6570\u306fcount()\u306e\u4ed6\u306b\u3082\u591a\u6570\u3042\u308a\u307e\u3059\u3002<\/p>\n WITH\u53e5\u306f\u5b9f\u8df5\u7684\u306aCypher\u3067\u3068\u3066\u3082\u91cd\u8981\u306a\u5f79\u5272\u3092\u679c\u305f\u3057\u307e\u3059\u3002<\/p>\n UNION ALL\u306f\u8907\u6570\u306e\u30af\u30a8\u30ea\u306e\u7d50\u679c\u5024\u3092\u7121\u64cd\u4f5c\u3067\u7d50\u5408\u3057\u307e\u3059\u3002<\/p>\n UNION\u306f\u8907\u6570\u306e\u30af\u30a8\u30ea\u306e\u7d50\u679c\u5024\u306e\u91cd\u8907\u3092\u6392\u9664\u3057\u307e\u3059\u3002<\/p>\n \n\u2003<\/p>\n CALL { Cypher\u69cb\u6587 }\u306e\u3088\u3046\u306b\u30cd\u30b9\u30c8\u3057\u305f\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3001\u305d\u306e\u30ea\u30bf\u30fc\u30f3\u5024\u3092\u4e0a\u4f4d\u306e\u30af\u30a8\u30ea\u30d6\u30ed\u30c3\u30af\u304b\u3089\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n \u30e0\u30fc\u30d3\u30fc\u30b0\u30e9\u30d5\u306b\u30ce\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \n \u30b3\u30f3\u30de\u533a\u5207\u308a\u3067\u8907\u6570\u306e\u30ce\u30fc\u30c9\u3092\u767b\u9332\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u7d50\u679c\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n SET\u53e5\u306f\u30d7\u30ed\u30d1\u30c6\u30ad\u30fc\u304c\u5b58\u5728\u3059\u308c\u3070\u4e0a\u66f8\u304d\u3057\u3001\u5b58\u5728\u3057\u306a\u3051\u308c\u3070\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n \n m.lengthInMinutes\u3092\u5909\u66f4\u3057\u3001m.unitPrice\u3092\u8ffd\u52a0\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \n \u6b21\u306e\u3088\u3046\u306b\u30de\u30c3\u30d7\u5f62\u5f0f\u3067\u6307\u5b9a\u3059\u308b\u3068\u3001\u65e2\u5b58\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u3059\u3079\u3066\u30ea\u30bb\u30c3\u30c8\u3057\u307e\u3059\u3002<\/p>\n \n \u6b21\u306e\u3088\u3046\u306b\u30de\u30c3\u30d7\u5f62\u5f0f\u3067\u6307\u5b9a\u3059\u308b\u3068\u3001\u65e2\u5b58\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u30de\u30fc\u30b8\u3057\u307e\u3059\u3002<\/p>\n \n \u30d7\u30ed\u30d1\u30c6\u30a3\u30ad\u30fc\u3092\u524a\u9664\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u51fa\u6f14\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \n \u51fa\u6f14\u3068\u30d7\u30ed\u30c7\u30e5\u30fc\u30b9\u306e\u8907\u6570\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \n \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306b\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u767b\u9332\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u524a\u9664\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n Batman Begins\u306e\u30d1\u30bf\u30fc\u30f3\u3092\u8868\u793a\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \n Christian Bale\u30ce\u30fc\u30c9\u3092\u524a\u9664\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u3053\u306e\u3088\u3046\u306b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u3001\u305d\u306e\u30ce\u30fc\u30c9\u306f\u524a\u9664\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u524a\u9664\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u304c\u524a\u9664\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n \u3067\u306f\u3001\u30ce\u30fc\u30c9\u3092\u524a\u9664\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u78ba\u8a8d\u3067\u304d\u3066\u306a\u3044\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u304c\u5b58\u5728\u3057\u3066\u3044\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n \n \u3053\u306e\u3088\u3046\u306a\u30ce\u30fc\u30c9\u306e\u524a\u9664\u306fDETACH\u53e5\u3092\u4f75\u7528\u3059\u308b\u3053\u3068\u3067\u5f37\u5236\u7684\u306b\u524a\u9664\u3067\u304d\u307e\u3059\u3002<\/p>\n \u6b21\u306e\u3088\u3046\u306b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3068\u30ce\u30fc\u30c9\u306f\u540c\u6642\u306b\u524a\u9664\u3067\u304d\u307e\u3059\u3002<\/p>\n \u2003<\/p>\n \u30ce\u30fc\u30c9\u304c\u5b58\u5728\u3057\u306a\u3051\u308c\u3070\u767b\u9332\u3057\u3001\u5b58\u5728\u3059\u308c\u3070\u66f4\u65b0\u3057\u307e\u3059\u3002 \n Actor\u30e9\u30d9\u30eb\u3067Michael Caine\u30ce\u30fc\u30c9\u3092\u30de\u30fc\u30b8\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \n \u6b21\u306e\u3088\u3046\u306bMichael Caine\u3092\u691c\u7d22\u3057\u3066\u307f\u308b\u3068\u3001\u30e9\u30d9\u30eb\u9055\u3044\u3067\u300cMichael Caine\u300d\u304c2\u3064\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n Actor\u30e9\u30d9\u30eb\u306eMichael Caine\u306e\u30de\u30fc\u30b8\u3092\u5b9f\u884c\u3057\u3066\u307f\u307e\u3059\u3002 \n \n \u30ce\u30fc\u30c9\u304c\u5b58\u5728\u3059\u308b\u3068\u304d\u3068\u5b58\u5728\u3057\u306a\u3044\u3068\u304d\u306b\u5206\u3051\u3066SET\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n ON CREATE\u3000SET\u53e5\u3092\u4f7f\u3063\u3066Sir Michael Caine\u3068\u3044\u3046\u540d\u524d\u3067\u30de\u30fc\u30b8\u3092\u5b9f\u884c\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u7d50\u679c\u3092\u307f\u308b\u3068\u3001\u540d\u524d\u304c\u7570\u306a\u308b\u305f\u3081\u306b\u30ce\u30fc\u30c9\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3059\u3002<\/p>\n \n \u3082\u3046\u4e00\u56de\u3001ON CREATE\u3000SET\u53e5\u3092\u4f7f\u3063\u3066Sir Michael Caine\u306e\u30de\u30fc\u30b8\u3092\u5b9f\u884c\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u7d50\u679c\u3092\u898b\u308b\u3068\u30b9\u30eb\u30fc\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u304c\u5206\u304b\u308a\u307e\u3059\uff08\u3059\u3067\u306b\u5b58\u5728\u3059\u308b\u305f\u3081\u306b\uff09\u3002<\/p>\n ON MATCH\u3000SET\u53e5\u3092\u4f7f\u3063\u3066Sir Michael Caine\u306e\u30de\u30fc\u30b8\u5b9f\u884c\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n \u4eca\u56de\u306f\u53cd\u6620\u3055\u308c\u3066\u3044\u307e\u3059\u3002 \u8981\u4ef6\u306b\u5fdc\u3058\u3066ON CREATE SET\u3068ON MATCH SET\u306f\u30da\u30a2\u3067\u4f7f\u7528\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n Caine\u3067\u7d42\u308f\u308b\u540d\u524d\u306e\u4eba\u3092Batman Begins\u306b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u5f35\u308a\u307e\u3059\u3002<\/p>\n \u4ee5\u4e0a\u3001\u4eca\u56de\u306e\u8a18\u4e8b\u306fNeo4j\u306e\u30aa\u30f3\u30e9\u30a4\u30f3\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u304b\u3089\u57fa\u790e\u7684\u306a\u69cb\u6587\u3092\u9078\u5225\u3057\u3066\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002 Neo4j\u306e\u30aa\u30f3\u30e9\u30a4\u30f3\u30c8\u30ec\u30fc\u30cb\u30f3\u30b0\u306f\u3053\u3061\u3089\u3067\u3059\u3002 \u516c\u5f0f\u30de\u30cb\u30e5\u30a2\u30eb\u306f\u30b7\u30f3\u30bf\u30c3\u30af\u30b9\u306e\u7406\u89e3\u306b\u306f\u6b20\u304b\u305b\u307e\u305b\u3093\u3002 \u5b9f\u8df5\u306b\u53c2\u8003\u306b\u306a\u308a\u305d\u3046\u306a\u4f8b\u6587\u3092\u63a2\u3057\u3066\u3044\u308b\u4eba\u306f\u3001\u30b5\u30f3\u30d7\u30eb\u30b0\u30e9\u30d5\u96c6(GraphGists)\u304c\u304a\u3059\u3059\u3081\u3067\u3059\u3002 \u30aa\u30f3\u30e9\u30a4\u30f3\u30b5\u30f3\u30c9\u30dc\u30c3\u30af\u30b9\u3067\u306f\u5b9f\u8df5\u7684\u306a\u30c7\u30fc\u30bf\u30e2\u30c7\u30eb\u306e\u898b\u805e\u3092\u5e83\u3052\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
\nA-LIKES->B-LIKES->C<-LIKES->A<\/strong>\u306e\u3088\u3046\u306b\u8868\u73fe\u3057\u307e\u3059\u3002<\/p>\n\n
\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-1.png\")
<\/p>\n\u30b0\u30e9\u30d5\u30e2\u30c7\u30eb<\/h2>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-2.png\")
<\/p>\n\u30ce\u30fc\u30c9(\u9802\u70b9)<\/h3>\n
\n
\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\uff08\u8fba\uff09<\/h3>\n
\n
\u30d7\u30ed\u30d1\u30c6\u30a3<\/h3>\n
\n()-[:MARRIED {key1:value1, key2:value2, \u2026}->()<\/strong><\/p>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-3.png\")
<\/p>\n
\n\u9ed2\u304f\u306c\u308a\u6f70\u3055\u308c\u3066\u3044\u308b\u7b87\u6240\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u304c\u5bc6\u96c6\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Panama-paper-1.png\")
<\/p>\n
\n\u51fa\u6240: https:\/\/neo4j.com\/sandbox\/<\/p>\nCypher\u306e\u5b9f\u884c\u74b0\u5883<\/h2>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-4.png\")
<\/p>\n\u30ce\u30fc\u30c9\u306e\u30d5\u30a3\u30eb\u30bf\u30fc<\/h2>\n
\u30ce\u30fc\u30c9\u306e\u30a2\u30b9\u30ad\u30fc\u30a2\u30fc\u30c8\u8868\u73fe<\/h3>\n
\n(p)
\n(:Person)\u3000\u3000\/\/\u533f\u540d\u306e\u8b58\u5225\u5b50\u306f\u30af\u30a8\u30ea\u304b\u3089\u53c2\u7167\u3067\u304d\u307e\u305b\u3093
\n(p:Person)\u3000 \/\/\u8b58\u5225\u5b50(p)\u306f\u30af\u30a8\u30ea\u304b\u3089\u53c2\u7167\u3067\u304d\u307e\u3059
\n(p:Person:Actor) \/\/\u30e9\u30d9\u30eb\u306f\u968e\u5c64\u5316\u3067\u304d\u307e\u3059<\/p>\n\u7279\u5b9a\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u30d5\u30a3\u30eb\u30bf\u30fc<\/h3>\n
\r\nMATCH (p:Person {born: 1970})\r\nRETURN p \r\n<\/pre>\n<\/p>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-5.png\")
<\/p>\n\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u30a2\u30b9\u30ad\u30fc\u30a2\u30fc\u30c8\u8868\u73fe<\/h3>\n
\n()-->()
\n()<--()
\n()-[ * ]-()
\n()-[ *0..10]-()
\n()-[ *0..]-()
\n()-[r]-()\u3000\u3000\u3000\u3000\u3000\u3000
\n()-[r:MARRIED]-()
\n()-[r:MARRIED]->() \u3000\/\/\u8b58\u5225\u5b50\u306f\u30af\u30a8\u30ea\u3067\u53c2\u7167\u3067\u304d\u307e\u3059
\n()<-[:MARRIED]-() \u3000\/\/\u533f\u540d\u306e\u8b58\u5225\u5b50\u306fCypher\u306e\u306a\u304b\u3067\u53c2\u7167\u3067\u304d\u307e\u305b\u3093
\n()-[r:MARRIED|LIVES_AT]-()\u3000\/\/\u30bf\u30a4\u30d7\u306f\u8907\u6570\u8a2d\u5b9a\u3067\u304d\u307e\u3059(OR)<\/p>\n\u7279\u5b9a\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u3092\u30d5\u30a3\u30eb\u30bf\u30fc<\/h3>\n
\r\nMATCH (p:Person)-[rel:ACTED_IN]->(m:Movie {title: 'The Matrix'}) \r\nRETURN p, rel, m \r\n<\/pre>\n<\/p>\n\r\nMATCH (p)-[rel:ACTED_IN]->(m:Movie {title: 'The Matrix'}) \r\nRETURN p, rel, m \r\n<\/pre>\n<\/p>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-7.png\")
<\/p>\n\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u30bf\u30a4\u30d7\u3092\u53d6\u5f97<\/h3>\n
\r\nMATCH (p:Person)-[rel]->(m:Movie {title:'The Matrix'}) \r\nRETURN p.name, type(rel) , m.title\r\np.name type(rel) m.title\r\n"Joel Silver" "PRODUCED" "The Matrix"\r\n"Emil Eifrem" "ACTED_IN" "The Matrix"\r\n"Laurence Fishburne" "ACTED_IN" "The Matrix"\r\n"Lana Wachowski" "DIRECTED" "The Matrix"\r\n"Hugo Weaving" "ACTED_IN" "The Matrix"\r\n"Lilly Wachowski" "DIRECTED" "The Matrix"\r\n"Carrie-Anne Moss" "ACTED_IN" "The Matrix"\r\n"Keanu Reeves" "ACTED_IN" "The Matrix"\r\n<\/pre>\n<\/p>\n\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u53d6\u5f97<\/h3>\n
\r\nMATCH (p:Person)-[r:REVIEWED {rating: 65}]->(m:Movie {title: 'The Da Vinci Code'}) \r\nRETURN p.name, r.rating, m.title \r\np.name r.rating m.tit\r\n"James Thompson" 65 "The Da Vinci Code"\r\n<\/pre>\n<\/p>\n\u63a8\u5968\u306eCypher\u30b9\u30bf\u30a4\u30eb<\/h3>\n
\n
\n\u3000\u3000\/* hogehoge *\/\n<\/ul>\nWHERE\u306b\u3088\u308b\u30d5\u30a3\u30eb\u30bf\u30fc<\/h2>\n
\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie {released: 2008}) \r\nRETURN p, m \r\n<\/pre>\n<\/p>\n\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie) \r\nWHERE m.released = 2008 \r\nRETURN p, m \r\n<\/pre>\n<\/p>\n
WHERE\u306b\u7bc4\u56f2\u306e\u30d5\u30a3\u30eb\u30bf\u30fc<\/h3>\n
\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie) \r\nWHERE m.released >= 2003 AND m.released <= 2004 \r\nRETURN p.name, m.title, m.released\r\np.name m.title m.released\r\n"Hugo Weaving" "The Matrix Reloaded" 2003\r\n"Laurence Fishburne" "The Matrix Reloaded" 2003\r\n"Carrie-Anne Moss" "The Matrix Reloaded" 2003\r\n"Keanu Reeves" "The Matrix Reloaded" 2003\r\n"Hugo Weaving" "The Matrix Revolutions" 2003\r\n"Laurence Fishburne" "The Matrix Revolutions" 2003\r\n"Carrie-Anne Moss" "The Matrix Revolutions" 2003\r\n"Keanu Reeves" "The Matrix Revolutions" 2003\r\n"Keanu Reeves" "Something's Gotta Give" 2003\r\n<\/pre>\n<\/p>\n
\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie)\r\nWHERE 2003 <= m.released <= 2004 \r\nRETURN p.name, m.title, m.released \r\np.name m.title m.released\r\n"Hugo Weaving" "The Matrix Reloaded" 2003\r\n"Laurence Fishburne" "The Matrix Reloaded" 2003\r\n"Carrie-Anne Moss" "The Matrix Reloaded" 2003\r\n"Keanu Reeves" "The Matrix Reloaded" 2003\r\n"Hugo Weaving" "The Matrix Revolutions" 2003\r\n"Laurence Fishburne" "The Matrix Revolutions" 2003\r\n"Carrie-Anne Moss" "The Matrix Revolutions" 2003\r\n"Keanu Reeves" "The Matrix Revolutions" 2003\r\n"Keanu Reeves" "Something's Gotta Give" 2003\r\n<\/pre>\n<\/p>\n
exists()<\/h3>\n
\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie) \r\nWHERE p.name='Jack Nicholson' AND exists(m.tagline) \r\nRETURN m.title, m.tagline \r\nLIMIT 5\r\nm.title m.tagline\r\n"A Few Good Men" "In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth."\r\n"As Good as It Gets" "A comedy from the heart that goes for the throat."\r\n"Hoffa" "He didn't want law. He wanted justice."\r\n"One Flew Over the Cuckoo's Nest"\r\n<\/pre>\n<\/p>\n
\u6b63\u898f\u8868\u73fe<\/h3>\n
\r\nMATCH (p:Person) \r\nWHERE p.name =~'Tom.*' \r\nRETURN p.name \r\np.name\r\n"Tom Cruise"\r\n"Tom Skerritt"\r\n"Tom Hanks"\r\n"Tom Tykwer"\r\n<\/pre>\n<\/p>\n
IN<\/h3>\n
\r\nMATCH (p:Person) \r\nWHERE p.born IN [1965, 1970] \r\nRETURN p.name as name, p.born as yearBorn \r\nLIMIT 5\r\nname yearBorn\r\n"Lana Wachowski" 1965\r\n"Jay Mohr" 1970\r\n"River Phoenix" 1970\r\n"Ethan Hawke" 1970\r\n"Brooke Langton" 1970\r\n<\/pre>\n<\/p>\n
\r\nMATCH (p:Person)-[r:ACTED_IN]->(m:Movie) \r\nWHERE 'Neo' IN r.roles AND m.title='The Matrix' \r\nRETURN p.name \r\np.name\r\n"Keanu Reeves"\r\n<\/pre>\n<\/p>\n
ALL<\/h3>\n
\r\nWITH ["A","B","C","D","E"] AS list1, ["A","B","C","D","E","F"] AS list2\r\nWHERE ALL( x IN list1 WHERE x IN list2)\r\nRETURN list1\r\nlist1\r\n[A, B, C, D, E]\r\n<\/pre>\n<\/p>\n
NONE<\/h3>\n
\r\nWITH ["A","B","C","D","E"] AS list1, ["F","G"] AS list2\r\nWHERE NONE( x IN list1 WHERE x IN list2)\r\nRETURN list1\r\nlist1\r\n["A", "B", "C", "D", "E"]\r\n<\/pre>\n<\/p>\n
ANY<\/h3>\n
\r\nWITH ["A","B","C","D","E"] AS list1, ["A","F"] AS list2\r\nWHERE ANY( x IN list1 WHERE x IN list2)\r\nRETURN list1\r\nlist1\r\n["A", "B", "C", "D", "E"]\r\n<\/pre>\n
\r\nWITH ["A","B","C","D","E"] AS list1, ["C","D","K","O"] AS list2\r\nWHERE ANY( x IN list1 WHERE x IN list2)\r\nRETURN list1\r\nlist1\r\n["A", "B", "C", "D", "E"]\r\n<\/pre>\n<\/p>\n
SINGLE<\/h3>\n
\r\nWITH ["A","B","C","D","E"] AS list1, ["A","F","K"] AS list2\r\nWHERE SINGLE( x IN list1 WHERE x IN list2)\r\nRETURN list1\r\n["A", "B", "C", "D", "E"]\r\n<\/pre>\n
\r\nWITH ["A","B","C","D","E"] AS list1, ["A","E"] AS list2\r\nWHERE SINGLE( x IN list1 WHERE x IN list2)\r\nRETURN list1\r\n(no changes, no records)\r\n<\/pre>\n<\/p>\n
\u7d50\u679c\u5024\u306e\u5236\u5fa1<\/h2>\n
\u91cd\u8907\u3092\u6392\u9664(DISTINCT)<\/h3>\n
\r\nMATCH (p:Person)-[:DIRECTED | ACTED_IN]->(m:Movie) \r\nWHERE p.name = 'Tom Hanks' \r\nRETURN m.released, collect(m.title) AS movies\r\n\/\/RETURN m.released, collect(DISTINCT m.title) AS movies \r\nm.released movies\r\n1992 ["A League of Their Own"]\r\n2012 ["Cloud Atlas"]\r\n2006 ["The Da Vinci Code"]\r\n1993 ["Sleepless in Seattle"]\r\n2004 ["The Polar Express"]\r\n1999 ["The Green Mile"]\r\n2000 ["Cast Away"]\r\n2007 ["Charlie Wilson's War"]\r\n1996 ["That Thing You Do", "That Thing You Do"]\r\n<\/pre>\n<\/p>\n
\r\nMATCH (p:Person)-[:DIRECTED | ACTED_IN]->(m:Movie) \r\nWHERE p.name = 'Tom Hanks' \r\n\/\/RETURN m.released, collect(m.title) AS movies\r\nRETURN m.released, collect(DISTINCT m.title) AS movies \r\nm.released movies\r\n1992 ["A League of Their Own"]\r\n2012 ["Cloud Atlas"]\r\n2006 ["The Da Vinci Code"]\r\n1993 ["Sleepless in Seattle"]\r\n2004 ["The Polar Express"]\r\n1999 ["The Green Mile"]\r\n2000 ["Cast Away"]\r\n2007 ["Charlie Wilson's War"]\r\n1996 ["That Thing You Do"]\r\n<\/pre>\n<\/p>\n
\r\nMATCH (p:Person)-[:DIRECTED | ACTED_IN]->(m:Movie) \r\nWHERE p.name = 'Tom Hanks' \r\n\/\/WITH m\r\nWITH DISTINCT m \r\nRETURN m.released, m.title \r\nm.released movies\r\n1992 ["A League of Their Own"]\r\n2012 ["Cloud Atlas"]\r\n2006 ["The Da Vinci Code"]\r\n1993 ["Sleepless in Seattle"]\r\n2004 ["The Polar Express"]\r\n1999 ["The Green Mile"]\r\n2000 ["Cast Away"]\r\n2007 ["Charlie Wilson's War"]\r\n1996 ["That Thing You Do"]\r\n<\/pre>\n<\/p>\n
\u30bd\u30fc\u30c8(ORDER BY)<\/h3>\n
\r\nMATCH (p:Person)-[:DIRECTED | ACTED_IN]->(m:Movie) \r\nWHERE p.name = 'Tom Hanks' \r\nRETURN m.released, collect(DISTINCT m.title) AS movies \r\nORDER BY m.released DESC \r\nm.released movies\r\n2012 ["Cloud Atlas"]\r\n2007 ["Charlie Wilson's War"]\r\n2006 ["The Da Vinci Code"]\r\n2004 ["The Polar Express"]\r\n2000 ["Cast Away"]\r\n1999 ["The Green Mile"]\r\n1998 ["You've Got Mail"]\r\n1996 ["That Thing You Do"]\r\n1995 ["Apollo 13"]\r\n<\/pre>\n<\/p>\n
\r\nMATCH (p:Person)-[:DIRECTED | ACTED_IN]->(m:Movie) \r\nWHERE p.name = 'Tom Hanks' \r\nRETURN m.released, collect(DISTINCT m.title) AS movies \r\nORDER BY m.released ASC \r\nm.released movies\r\n1990 ["Joe Versus the Volcano"]\r\n1992 ["A League of Their Own"]\r\n1993 ["Sleepless in Seattle"]\r\n1995 ["Apollo 13"]\r\n1996 ["That Thing You Do"]\r\n1998 ["You've Got Mail"]\r\n1999 ["The Green Mile"]\r\n2000 ["Cast Away"]\r\n2004 ["The Polar Express"]\r\n<\/pre>\n<\/p>\n
\u6570\u3092\u5236\u9650(LIMIT)<\/h3>\n
\r\nMATCH (p:Person)-[:DIRECTED | ACTED_IN]->(m:Movie) \r\nWHERE p.name = 'Tom Hanks' \r\nRETURN m.released, collect(DISTINCT m.title) AS movies \r\nORDER BY m.released DESC \r\nLIMIT 5\r\nm.released movies\r\n2012 ["Cloud Atlas"]\r\n2007 ["Charlie Wilson's War"]\r\n2006 ["The Da Vinci Code"]\r\n2004 ["The Polar Express"]\r\n2000 ["Cast Away"]\r\n<\/pre>\n<\/p>\n
\u30ea\u30b9\u30c8\u5316(collect)<\/h3>\n
\r\nMATCH (a:Person)-[:ACTED_IN]->(m:Movie) \r\nWITH m, count(m) AS numCast, collect(a.name) as cast \r\nRETURN m.title, cast, numCast \r\nORDER BY size(cast) \r\nm.title cast numCast\r\n"The Polar Express" ["Tom Hanks"] 1\r\n"Cast Away" ["Tom Hanks", "Helen Hunt"] 2\r\n"One Flew Over the Cuckoo's Nest" ["Jack Nicholson", "Danny DeVito"] 2\r\n"Bicentennial Man" ["Oliver Platt", "Robin Williams"] 2\r\n"The Devil's Advocate" ["Charlize Theron", "Keanu Reeves", "Al Pacino"] 3\r\n"Joe Versus the Volcano" ["Tom Hanks", "Nathan Lane", "Meg Ryan"] 3\r\n"That Thing You Do" ["Tom Hanks", "Liv Tyler", "Charlize Theron"] 3\r\n<\/pre>\n<\/p>\n
\u30ea\u30b9\u30c8\u3092\u7e26\u306b\u51fa\u529b(UNWIND)<\/h3>\n
\r\nWITH [1, 2, 3] AS list \r\nUNWIND list AS row \r\nRETURN list, row \r\nlist row\r\n[1, 2, 3] 1\r\n[1, 2, 3] 2\r\n[1, 2, 3] 3\r\n<\/pre>\n<\/p>\n
\r\nMATCH (:Person {name:'Tom Hanks'})-->(movie) \r\nWITH collect(movie.title) AS list UNWIND list AS titles\r\n\/\/RETURN titles \r\nMATCH (m:Movie {title : titles})\r\nRETURN m.title, m.released\r\nm.title m.released\r\n"A League of Their Own" 1992\r\n"Cloud Atlas" 2012\r\n"The Da Vinci Code" 2006\r\n"Sleepless in Seattle" 1993\r\n"The Polar Express" 2004\r\n"The Green Mile" 1999\r\n"Cast Away" 2000\r\n"Charlie Wilson's War" 2007\r\n"That Thing You Do" 1996\r\n<\/pre>\n<\/p>\n\u65e5\u4ed8\u51e6\u7406(date,datetime)<\/h3>\n
\r\nMATCH (actor:Person)-[:ACTED_IN]->(:Movie) \r\nWHERE exists(actor.born) \r\nWITH DISTINCT actor, date().year - actor.born as age \r\nRETURN actor.name, age as <code>age today<\/code> \r\nORDER BY actor.born DESC \r\nactor.name age today\r\n"Jonathan Lipnicki" 24\r\n"Emile Hirsch" 35\r\n"Rain" 38\r\n"Natalie Portman" 39\r\n"Christina Ricci" 40\r\n"Emil Eifrem" 42\r\n"Liv Tyler" 43\r\n"Audrey Tautou" 44\r\n"Charlize Theron" 45\r\n"Jerry O'Connell" 46\r\n<\/pre>\n<\/p>\n
\r\nRETURN date(), date().year, date().month, date().day\r\ndate() date().year date().month date().day\r\n"2020-03-20" 2020 3 20\r\n<\/pre>\n<\/p>\n
\r\nRETURN datetime(), datetime().hour, datetime().minute, datetime().second\r\ndatetime() datetime().hour datetime().minute datetime().second\r\n"2020-03-20T13:31:31.741000000Z" 13 31 31\r\n<\/pre>\n<\/p>\n
\u30a2\u30a6\u30bf\u30fc\u30b8\u30e7\u30f3\u306e\u3088\u3046\u306a\u53e5(OPTIONAL MATCH)<\/h3>\n
\r\nMATCH (p:Person) \r\nWHERE p.name STARTS WITH 'James'\r\nOPTIONAL MATCH (p)-[r:REVIEWED]->(m:Movie) \r\nRETURN labels(p),p.name, type(r), m.title \r\nlabels(p) p.name type(r) labels(m) m.title\r\n["Person"] "James Marshall" null null null\r\n["Person"] "James L. Brooks" null null null\r\n["Person"] "James Cromwell" null null null\r\n["Person"] "James Thompson" "REVIEWED" ["Movie"] "The Replacements"\r\n["Person"] "James Thompson" "REVIEWED" ["Movie"] "The Da Vinci Code"\r\n<\/pre>\n<\/p>\n
\u96c6\u5408(collect)<\/h3>\n
\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie) \r\nWHERE p.name ='Tom Cruise' \r\nRETURN p.name,m.title\r\np.name m.title\r\n"Tom Cruise" "Jerry Maguire"\r\n"Tom Cruise" "Top Gun"\r\n"Tom Cruise" "A Few Good Men"\r\n<\/pre>\n<\/p>\n
\n\u96c6\u5408\u95a2\u6570\u306e\u524d\u306e\u5217\u306f\u6697\u9ed9\u7684\u306b\u30b0\u30eb\u30fc\u30d7\u5316\u3055\u308c\u307e\u3059(GROUP BY\u53e5\u306f\u5b58\u5728\u3057\u307e\u305b\u3093)\u3002<\/p>\n\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie) \r\nWHERE p.name ='Tom Cruise' \r\nRETURN p.name,collect(m.title)\r\np.name collect(m.title)\r\n"Tom Cruise" ["Jerry Maguire", "Top Gun", "A Few Good Men"]\r\n<\/pre>\n<\/p>\n
\u96c6\u8a08(aggregation)<\/h3>\n
\n\u96c6\u8a08\u95a2\u6570\u306e\u524d\u306e\u5217\u306f\u6697\u9ed9\u7684\u306b\u30b0\u30eb\u30fc\u30d7\u5316\u3055\u308c\u307e\u3059(GROUP BY\u53e5\u306f\u5b58\u5728\u3057\u307e\u305b\u3093)\u3002<\/p>\n\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie) \r\nWHERE p.name ='Tom Cruise' \r\nRETURN p.name,count(m.title)\r\np.name count(m.title)\r\n"Tom Cruise" 3\r\n<\/pre>\n<\/p>\n
\r\nMATCH (p:Person)-[:ACTED_IN]->(m:Movie) \r\nWHERE p.name ='Tom Cruise' \r\nRETURN p.name,count(m.title), collect(m.title)\r\np.name count(m.title) collect(m.title)\r\n"Tom Cruise" 3 ["Jerry Maguire", "Top Gun", "A Few Good Men"]\r\n<\/pre>\n<\/p>\n
\n
WITH<\/h3>\n
\n
\r\nMATCH (a:Person)-[:ACTED_IN]->(m:Movie) \r\nWITH a, count(a) AS numMovies, collect(m.title) as movies \r\nWHERE numMovies > 1 AND numMovies < 4 \r\nRETURN a.name, numMovies, movies \r\na.name numMovies movies\r\n"Laurence Fishburne" 3 ["The Matrix", "The Matrix Reloaded", "The Matrix Revolutions"]\r\n"Carrie-Anne Moss" 3 ["The Matrix", "The Matrix Reloaded", "The Matrix Revolutions"]\r\n"Charlize Theron" 2 ["The Devil's Advocate", "That Thing You Do"]\r\n"Tom Cruise" 3 ["A Few Good Men", "Top Gun", "Jerry Maguire"]\r\n"Kevin Bacon" 3 ["A Few Good Men", "Frost\/Nixon", "Apollo 13"]\r\n"Kiefer Sutherland" 2 ["A Few Good Men", "Stand By Me"]\r\n"J.T. Walsh" 2 ["A Few Good Men", "Hoffa"]\r\n"Bonnie Hunt" 2 ["Jerry Maguire", "The Green Mile"]\r\n"Jerry O'Connell" 2 ["Jerry Maguire", "Stand By Me"]\r\n<\/pre>\n<\/p>\n
UNION<\/h3>\n
\r\nWITH [1,2,3,4,5] AS list UNWIND list AS n RETURN n\r\nUNION ALL \r\nWITH [1,2,3,4,5] AS list UNWIND list AS n RETURN n\r\nn\r\n1\r\n2\r\n3\r\n4\r\n5\r\n1\r\n2\r\n3\r\n4\r\n5\r\n<\/pre>\n<\/p>\n
\r\nWITH [1,2,3,4,5] AS list UNWIND list AS n RETURN n\r\nUNION\r\nWITH [1,2,3,4,5] AS list UNWIND list AS n RETURN n\r\nn\r\n1\r\n2\r\n3\r\n4\r\n5\r\n<\/pre>\n
\u30b5\u30d6\u30af\u30a8\u30ea<\/h3>\n
\r\nCALL {\r\n CALL {\r\n MATCH (p:Person) WHERE p.name = 'Tom Hanks' RETURN p\r\n }\r\n RETURN p\r\n}\r\nRETURN p.name\r\np.name\r\n"Tom Hanks"\r\n<\/pre>\n<\/p>\n\u30ce\u30fc\u30c9\u3068\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u767b\u9332\u30fb\u66f4\u65b0<\/h2>\n
\u30b7\u30f3\u30b0\u30eb\u30ce\u30fc\u30c9\u306e\u767b\u9332(CREATE)<\/h3>\n
\r\nCREATE (m:Movie {title: \u2018Batman Begins\u2019}) \r\nRETURN m\r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-10-1.png\")
<\/p>\n\u30de\u30eb\u30c1\u30ce\u30fc\u30c9\u306e\u767b\u9332<\/h3>\n
\r\nCREATE \r\n(:Person {name: 'Michael Caine', born: 1933}), \r\n(:Person {name: 'Liam Neeson', born: 1952}), \r\n(:Person {name: 'Katie Holmes', born: 1978}), \r\n(:Person {name: 'Benjamin Melniker', born: 1913}) \r\n<\/pre>\n<\/p>\n\r\nMATCH (p:Person) \r\nWHERE p.name IN ['Michael Caine','Liam Neeson','Katie Holmes' ,'Benjamin Melniker']\r\nRETURN id(p), labels(p),p.name\r\nid(p) labels(p) p.name\r\n172 ["Person"] "Michael Caine"\r\n173 ["Person"] "Liam Neeson"\r\n174 ["Person"] "Katie Holmes"\r\n175 ["Person"] "Benjamin Melniker"\r\n<\/pre>\n<\/p>\n
\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u30de\u30fc\u30b8( SET \u30d7\u30ed\u30d1\u30c6\u30a3 = )<\/h3>\n
\r\nMATCH (m:Movie) \r\nWHERE m.title = 'Batman Begins' \r\nSET m.released = 2005, m.lengthInMinutes = 140 \r\nRETURN m\r\n<\/pre>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-11-1.png\")
<\/p>\n\r\nMATCH (m:Movie)\r\nWHERE m.title = \u2018Batman Begins\u2019\r\nSET m.released = 2005, m.lengthInMinutes = 240, m.unitPrice= 25\r\nRETURN m\r\n<\/pre>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-12-1.png\")
<\/p>\n\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u5168\u3066\u30ea\u30bb\u30c3\u30c8 (SET\u3000\u8b58\u5225\u5b50 = )<\/h3>\n
\n
\r\nMATCH (m:Movie) \r\nWHERE m.title = 'Batman Begins' \r\nSET m = { title: 'Batman Begins', \r\nreleased : 2005, \r\nlengthInMinutes : 140\r\n}\r\nRETURN m\r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-13.png\")
<\/p>\n\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u30de\u30fc\u30b8 (SET <\u8b58\u5225\u5b50> +=)<\/h3>\n
\n
\r\nMATCH (m:Movie) \r\nWHERE m.title = 'Batman Begins' \r\nSET m += { \r\nlengthInMinutes : 150,\r\n videoFormat: 'DVD', \r\n unitPrice : 25\r\n} \r\nRETURN m\r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-13-1.png\")
<\/p>\n\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u524a\u9664(NULL or REMOVE)<\/h3>\n
\n
\r\nMATCH (m:Movie) \r\nWHERE m.title = \u2018Batman Begins\u2019 \r\nSET m.unitPrice = null REMOVE m.videoFormat \r\nRETURN m\r\n<\/pre>\n<\/p>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-14.png\")
<\/p>\n\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u767b\u9332(CREATE)<\/h3>\n
\r\nMATCH (a:Person), (m:Movie) \r\nWHERE a.name = 'Michael Caine' AND m.title = 'Batman Begins' \r\nCREATE (a)-[:ACTED_IN]->(m) \r\nRETURN a, m \r\n<\/pre>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-15.png\")
<\/p>\n\r\nMATCH (a:Person), (m:Movie), (p:Person) \r\nWHERE a.name = 'Liam Neeson' AND m.title = 'Batman Begins' AND p.name = 'Benjamin Melniker' \r\nCREATE (a)-[:ACTED_IN]->(m)<-[:PRODUCED]-(p)\r\nRETURN a, m, p\r\n<\/pre>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-16.png\")
<\/p>\n\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u767b\u9332( SET \u30d7\u30ed\u30d1\u30c6\u30a3 = )<\/h3>\n
\r\nMATCH (a:Person), (m:Movie) \r\nWHERE a.name = 'Christian Bale' AND m.title = 'Batman Begins' \r\nCREATE (a)-[rel:ACTED_IN]->(m) \r\nSET rel.roles = ['Bruce Wayne','Batman'] \r\nRETURN a.name, type(rel), rel.roles, m.title\r\na.name type(rel) rel.roles m.title\r\n"Christian Bale" "ACTED_IN" ["Bruce Wayne", "Batman"] "Batman Begins"\r\n<\/pre>\n<\/p>\n
\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u524a\u9664(REMOVE)<\/h3>\n
\r\nMATCH (a:Person)-[rel:ACTED_IN]->(m:Movie) \r\nWHERE a.name = 'Christian Bale' AND m.title = 'Batman Begins' \r\nREMOVE rel.roles \r\nRETURN a.name, type(rel), rel.roles, m.title \r\na.name type(rel) rel.roles m.title\r\n"Christian Bale" "ACTED_IN" null "Batman Begins"\r\n<\/pre>\n<\/p>\n
\u30ce\u30fc\u30c9\u3068\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u524a\u9664(DELETE)<\/h3>\n
\r\nMATCH (a:Person)-->(m:Movie) \r\nWHERE m.title = 'Batman Begins' \r\nRETURN a, m \r\n<\/pre>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-17.png\")
<\/p>\n\r\nMATCH (a:Person)-[rel:ACTED_IN]->(m:Movie) \r\nWHERE a.name = 'Christian Bale' AND m.title = 'Batman Begins' \r\nDELETE a\r\nNeo.ClientError.Schema.ConstraintValidationFailed\r\nCannot delete node<93>, because it still has relationships. To delete this node, you must first delete its relationships.\r\n<\/pre>\n<\/p>\n
\r\nMATCH (a:Person)-[rel:ACTED_IN]->(m:Movie) \r\nWHERE a.name = 'Christian Bale' AND m.title = 'Batman Begins' \r\n\/\/RETURN a, m\r\nDELETE rel\r\nDeleted 1 relationship, completed after 4 ms.\r\n<\/pre>\n<\/p>\n
\r\nMATCH (a:Person), (m:Movie) \r\nWHERE a.name = 'Christian Bale' AND m.title = 'Batman Begins' \r\nRETURN a, m\r\n<\/pre>\n<\/p>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-18.png\")
<\/p>\n\r\nMATCH (a:Person)\r\nWHERE a.name = 'Christian Bale'\r\nDELETE a\r\nNeo.ClientError.Schema.ConstraintValidationFailed\r\nCannot delete node<93>, because it still has relationships. To delete this node, you must first delete its relationships.\r\n<\/pre>\n<\/p>\n
\r\nMATCH p=(a:Person)-->()\r\nWHERE a.name = 'Christian Bale'\r\nRETURN p\r\n<\/pre>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-19.png\")
<\/p>\n\n
\r\nMATCH (a:Person)\r\nWHERE a.name = 'Christian Bale'\r\nDETACH DELETE a\r\nDeleted 1 node, deleted 1 relationship, completed after 1 ms.\r\n<\/pre>\n<\/p>\n
\r\nMATCH (a:Person)-[rel:ACTED_IN]->(m:Movie)\r\nWHERE a.name = 'Liam Neeson'\r\n\/\/RETURN a,m\r\nDELETE a, rel\r\nDeleted 1 node, deleted 1 relationship, completed after 2 ms.\r\n<\/pre>\n<\/p>\n
\u30de\u30fc\u30b8\u306b\u3088\u308b\u767b\u9332\u30fb\u66f4\u65b0<\/h2>\n
\u30de\u30fc\u30b8\u306b\u3088\u308b\u30ce\u30fc\u30c9\u306e\u767b\u9332<\/h3>\n
\n\u307e\u305a\u3001Michael Caine\u30ce\u30fc\u30c9\u306e\u5b58\u5728\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n\r\nMATCH (a:Person {name: 'Michael Caine'}) \r\nRETURN a \r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-20.png\")
<\/p>\n\r\nMERGE (a:Actor {name: 'Michael Caine'}) \r\nSET a.born = 1933 \r\nRETURN a \r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-21.png\")
<\/p>\n\r\nMATCH (a { name: 'Michael Caine'}), (m:Movie) \r\nWHERE m.title = 'Batman Begins'\r\nRETURN a, m\r\n<\/pre>\n<\/p>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-22.png\")
<\/p>\n
\n\u3053\u306e\u51e6\u7406\u306f\u3001\u4f55\u5ea6\u5b9f\u884c\u3057\u3066\u3082\u4e0a\u66f8\u304d\u3055\u308c\u307e\u3059\u3002<\/p>\n\r\nMERGE (a:Actor {name: 'Michael Caine'}) \r\nSET a.born = 1933 \r\nRETURN a \r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-23.png\")
<\/p>\n\r\nMATCH (a { name: 'Michael Caine'}), (m:Movie) \r\nWHERE m.title = 'Batman Begins'\r\nRETURN a, m\r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-24.png\")
<\/p>\n\u30de\u30fc\u30b8\u306b\u3088\u308b\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u767b\u9332\u30fb\u66f4\u65b0(ON CREATE SET\/ON MATCH SET)<\/h3>\n
\n
\r\nMERGE (a:Person {name: 'Sir Michael Caine'}) \r\nON CREATE SET a.birthPlace = 'London',\r\n a.born = 1934 \r\nRETURN a \r\n<\/pre>\n<\/p>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-25.png\")
<\/p>\n\r\nMATCH (a), (m:Movie { title: 'Batman Begins'}) \r\nWHERE a.name ENDS WITH 'Caine'\r\nRETURN a, m\r\n<\/pre>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-26.png\")
<\/p>\n\r\nMERGE (a:Person {name: 'Sir Michael Caine'}) \r\nON CREATE SET a.birthPlace = 'UK',\r\n a.born = 1934\r\nRETURN a \r\n<\/pre>\n<\/p>\n![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-27.png\")
<\/p>\n\r\nMERGE (a:Person {name: 'Sir Michael Caine'}) \r\nON MATCH SET a.birthPlace = 'UK',\r\n a.born = 1934\r\nRETURN a \r\n<\/pre>\n<\/p>\n
\n ![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-28.png\")
<\/p>\n\u30de\u30fc\u30b8\u306b\u3088\u308b\u30ea\u30ec\u30fc\u30b7\u30e7\u30f3\u30b7\u30c3\u30d7\u306e\u767b\u9332<\/h3>\n
\r\nMATCH (p:Person), (m:Movie) \r\nWHERE m.title = 'Batman Begins' AND p.name ENDS WITH 'Caine' \r\nMERGE (p)-[:ACTED_IN]->(m) \r\nRETURN p, m \r\n<\/pre>\n<\/p>\n
![\"\"](\"\/tech-blog\/cms_x3GWkuX\/wp-content\/uploads\/2020\/03\/Basic-sypher-29.png\")
<\/p>\n\u307e\u3068\u3081<\/h2>\n
\n\u5b9f\u8df5\u306b\u304a\u3044\u3066\u306f\u3082\u3063\u3068\u5e83\u3044\u30ca\u30ec\u30c3\u30b8\u304c\u5fc5\u8981\u3067\u3057\u3087\u3046\u3002
\n\u53c2\u8003\u306b\u306a\u308a\u305d\u3046\u306a\u30b5\u30a4\u30c8\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n
\n\u57fa\u790e\u304b\u3089\u899a\u3048\u305f\u3044\u4eba\u306b\u304a\u3059\u3059\u3081\u3067\u3059\u3002
\nhttps:\/\/neo4j.com\/graphacademy\/online-training\/<\/a><\/p>\n
\nhttps:\/\/neo4j.com\/docs\/cypher-manual\/4.0\/<\/a><\/p>\n
\nhttps:\/\/neo4j.com\/graphgists\/<\/p>\n
\nhttps:\/\/neo4j.com\/sandbox\/<\/a><\/p>\n