参考:https://www.jianshu.com/p/9e3c4892ab3e
字符串操作:substring,replac、toupper、tolower
match(p:Person) return p order by p.name desc limit 3;
substring,replac、toupper、tolower为字符串处理函数
MATCH (n:letter) RETURN substring(n.name,0,1) --截取从第1位开始,取1位长度
MATCH (n:letter) RETURN toupper(n.name) --返回大写
MATCH (n:letter) RETURN replace(n.name,"b","abc") --把b替换成abc。
聚合函数:COUNT、MAX、MIN、AVG、SUM等五种
match(p:Person) return p.name as name,p.age as age,count(p) as count,max(p.age) as maxAge,min(p.age) as minAge,avg(p.age) as avgAge,sum(p.age) as sumAge
关系函数
序号 | 函数名 | 函数功能描述 |
---|---|---|
1 | STARTNODE | 查找关系的起始点 |
2 | ENDNODE | 查找关系的终点 |
3 | ID | 查找关系的ID |
4 | TYPE | 查找关系的类型,也就是我们在图表中看到的名称 |
创建节点,同时创建关系:
create
(accountOwner1:AccountOwner{FirstName:"Sylvia",LastName:"Song",UniqueID:"SylviaSong"}),
(accountOwner2:AccountOwner{FirstName:"Angle",LastName:"Hao",UniqueID:"AngleHao"}),
(accountOwner3:AccountOwner{FirstName:"Jacky",LastName:"Song",UniqueID:"JackySong"}),
(address1:Address{Street:"123 NW1st Street",City:"Beijing"}),
(accountOwner1)-[:HAS_ADDRESS]->(address1),
(accountOwner2)-[:HAS_ADDRESS]->(address1),
(accountOwner3)-[:HAS_ADDRESS]->(address1),
(phoneNumber1:PhoneNumber{PhoneNumber:"111-111-11111"}),
(phoneNumber2:PhoneNumber{PhoneNumber:"222-222-22222"})
<-[:HAS_PHONENUMBER]-(accountOwner3),
(accountOwner1)-[:HAS_PHONENUMBER]->(phoneNumber1),
(accountOwner2)-[:HAS_PHONENUMBER]->(phoneNumber1),
(SSN1:SSN{SSN:"241-23-1234"}),
(accountOwner2)-[:HAS_SSN]->(SSN1),
(accountOwner3)-[:HAS_SSN]->(SSN1),
(SSN2:SSN{SSN:"241-23-5678"}),
(accountOwner1)-[:HAS_SSN]->(SSN2),
(creditCard1:CreditCard{AccountNumber:"1234567890123456",
Limit:5000,
Balance:1442.23,
ExpirarionDate:"01-20",
SecurityCode:"123"})<-[:HAS_CREDITCARD]-(accountOwner1),
(creditCard2:CreditCard{AccountNumber:"1234567890123456",
Limit:4000,
Balance:2345.56,
ExpirarionDate:"02-20",
SecurityCode:"456"})<-[:HAS_CREDITCARD]-(accountOwner2),
(bankAccount1:BankAccount{AccountNumber:"2345678901234567",
Balance:7054.43})<-[:HAS_BANKACCOUNT]-(accountOwner1),
(bankAccount2:BankAccount{AccountNumber:"3456789012345678",
Balance:4231.12})<-[:HAS_BANKACCOUNT]-(accountOwner2),
(bankAccount3:BankAccount{AccountNumber:"4567890123456789",
Balance:12345.45})<-[:HAS_BANKACCOUNT]-(accountOwner3),
(unsecuredLoan1:UnsecuredLoan{AccountNumber:"4567890123456789-0",
Balance:9045.53,
APR:.0541,
LoanAmount:12000.00})<-[:HAS_UNSECUREDLOAN]-(accountOwner2),
(unsecuredLoan2:UnsecuredLoan{AccountNumber:"5678901234567890-0",
Balance:16341.95,
APR:.0341,
LoanAmount:22000.00})<-[:HAS_UNSECUREDLOAN]-(accountOwner3)