neo4jでsandbox その７

4629 ワード
sandbox 九九 neo4j sandbox テキストリンク

概要

neo4jでsandboxやってみた。
九九、やってみた。

データ投入


CREATE (p1:i {name:"p1"}),
(p2:i {name:"p2"}),
(p3:i {name:"p3"}),
(p4:i {name:"p4"}),
(p5:i {name:"p5"}),
(p6:i {name:"p6"}),
(p7:i {name:"p7"}),
(p8:i {name:"p8"}),
(p9:i {name:"p9"}),
(p10:i {name:"p10"}),
(p11:i {name:"p11"}),
(p12:i {name:"p12"}),
(p13:i {name:"p13"}),
(p14:i {name:"p14"}),
(p15:i {name:"p15"}),
(p16:i {name:"p16"}),
(p17:i {name:"p17"}),
(p18:i {name:"p18"}),
(p19:i {name:"p19"}),
(p20:i {name:"p20"}),
(p21:i {name:"p21"}),
(p22:i {name:"p22"}),
(p23:i {name:"p23"}),
(p24:i {name:"p24"}),
(p25:i {name:"p25"}),
(p26:i {name:"p26"}),
(p27:i {name:"p27"}),
(p28:i {name:"p28"}),
(p29:i {name:"p29"}),
(p30:i {name:"p30"}),
(p31:i {name:"p31"}),
(p32:i {name:"p32"}),
(p33:i {name:"p33"}),
(p34:i {name:"p34"}),
(p35:i {name:"p35"}),
(p36:i {name:"p36"}),
(p37:i {name:"p37"}),
(p38:i {name:"p38"}),
(p39:i {name:"p39"}),
(p40:i {name:"p40"}),
(p41:i {name:"p41"}),
(p42:i {name:"p42"}),
(p43:i {name:"p43"}),
(p44:i {name:"p44"}),
(p45:i {name:"p45"}),
(p46:i {name:"p46"}),
(p47:i {name:"p47"}),
(p48:i {name:"p48"}),
(p49:i {name:"p49"}),
(p50:i {name:"p50"}),
(p51:i {name:"p51"}),
(p52:i {name:"p52"}),
(p53:i {name:"p53"}),
(p54:i {name:"p54"}),
(p55:i {name:"p55"}),
(p56:i {name:"p56"}),
(p57:i {name:"p57"}),
(p58:i {name:"p58"}),
(p59:i {name:"p59"}),
(p60:i {name:"p60"}),
(p61:i {name:"p61"}),
(p62:i {name:"p62"}),
(p63:i {name:"p63"}),
(p64:i {name:"p64"}),
(p65:i {name:"p65"}),
(p66:i {name:"p66"}),
(p67:i {name:"p67"}),
(p68:i {name:"p68"}),
(p69:i {name:"p69"}),
(p70:i {name:"p70"}),
(p71:i {name:"p71"}),
(p72:i {name:"p72"}),
(p73:i {name:"p73"}),
(p74:i {name:"p74"}),
(p75:i {name:"p75"}),
(p76:i {name:"p76"}),
(p77:i {name:"p77"}),
(p78:i {name:"p78"}),
(p79:i {name:"p79"}),
(p80:i {name:"p80"}),
(p81:i {name:"p81"}),
(p1)-[:Kakeru1]->(p1),
(p2)-[:Kakeru1]->(p2),
(p3)-[:Kakeru1]->(p3),
(p4)-[:Kakeru1]->(p4),
(p5)-[:Kakeru1]->(p5),
(p6)-[:Kakeru1]->(p6),
(p7)-[:Kakeru1]->(p7),
(p8)-[:Kakeru1]->(p8),
(p9)-[:Kakeru1]->(p9),
(p1)-[:Kakeru2]->(p2),
(p2)-[:Kakeru2]->(p4),
(p3)-[:Kakeru2]->(p6),
(p4)-[:Kakeru2]->(p8),
(p5)-[:Kakeru2]->(p10),
(p6)-[:Kakeru2]->(p12),
(p7)-[:Kakeru2]->(p14),
(p8)-[:Kakeru2]->(p16),
(p9)-[:Kakeru2]->(p18),
(p1)-[:Kakeru3]->(p3),
(p2)-[:Kakeru3]->(p6),
(p3)-[:Kakeru3]->(p9),
(p4)-[:Kakeru3]->(p12),
(p5)-[:Kakeru3]->(p15),
(p6)-[:Kakeru3]->(p18),
(p7)-[:Kakeru3]->(p21),
(p8)-[:Kakeru3]->(p24),
(p9)-[:Kakeru3]->(p27),
(p1)-[:Kakeru4]->(p4),
(p2)-[:Kakeru4]->(p8),
(p3)-[:Kakeru4]->(p12),
(p4)-[:Kakeru4]->(p16),
(p5)-[:Kakeru4]->(p20),
(p6)-[:Kakeru4]->(p24),
(p7)-[:Kakeru4]->(p28),
(p8)-[:Kakeru4]->(p32),
(p9)-[:Kakeru4]->(p36),
(p1)-[:Kakeru5]->(p5),
(p2)-[:Kakeru5]->(p10),
(p3)-[:Kakeru5]->(p15),
(p4)-[:Kakeru5]->(p20),
(p5)-[:Kakeru5]->(p25),
(p6)-[:Kakeru5]->(p30),
(p7)-[:Kakeru5]->(p35),
(p8)-[:Kakeru5]->(p40),
(p9)-[:Kakeru5]->(p45),
(p1)-[:Kakeru6]->(p6),
(p2)-[:Kakeru6]->(p12),
(p3)-[:Kakeru6]->(p18),
(p4)-[:Kakeru6]->(p24),
(p5)-[:Kakeru6]->(p30),
(p6)-[:Kakeru6]->(p36),
(p7)-[:Kakeru6]->(p42),
(p8)-[:Kakeru6]->(p48),
(p9)-[:Kakeru6]->(p54),
(p1)-[:Kakeru7]->(p7),
(p2)-[:Kakeru7]->(p14),
(p3)-[:Kakeru7]->(p21),
(p4)-[:Kakeru7]->(p28),
(p5)-[:Kakeru7]->(p35),
(p6)-[:Kakeru7]->(p42),
(p7)-[:Kakeru7]->(p49),
(p8)-[:Kakeru7]->(p56),
(p9)-[:Kakeru7]->(p63),
(p1)-[:Kakeru8]->(p8),
(p2)-[:Kakeru8]->(p16),
(p3)-[:Kakeru8]->(p24),
(p4)-[:Kakeru8]->(p32),
(p5)-[:Kakeru8]->(p40),
(p6)-[:Kakeru8]->(p48),
(p7)-[:Kakeru8]->(p56),
(p8)-[:Kakeru8]->(p64),
(p9)-[:Kakeru8]->(p72),
(p1)-[:Kakeru9]->(p9),
(p2)-[:Kakeru9]->(p18),
(p3)-[:Kakeru9]->(p27),
(p4)-[:Kakeru9]->(p36),
(p5)-[:Kakeru9]->(p45),
(p6)-[:Kakeru9]->(p54),
(p7)-[:Kakeru9]->(p63),
(p8)-[:Kakeru9]->(p72),
(p9)-[:Kakeru9]->(p81)

写真

９かける９を求める。

match (:i {name:"p9"})-[:Kakeru9]->(m) return m

以上。