neo4j 删除节点及删除节点含有的关系

系统管理员 2021-05-10 11:18 825阅读 0赞

假设neo4j有以下图节点：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center]

## 1. 删除无关系节点 ##

#通过id值删除Lucy节点
    MATCH (n:Person{ name:'Lucy'}) DELETE n
    
    #通过name值删除Lucy节点
    MATCH (n) WHERE id(n) = 13416 DELETE n

效果：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 1]

## 2.删除指定节点直接的关系 ##

在这里如果我们删除含有关系的Steve节点

MATCH (n:Person{ name:'Steve'}) DELETE n

此时就有错误提示，告诉我们先删除该节点含有的关系。

Cannot delete node<13420>, because it still has relationships. To delete this node, 
    you must first delete its relationships.

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 2]  
删除语句的格式：

DELETE <node1-name>,<node2-name>,<relationship-name>

#删除Sally到Steve的节点关系
    MATCH (n1:Person{ name:'Sally'})-[r:FRIENDS]-(n2:Person{ name:'Steve'}) DELETE r

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 3]

## 3.删除节点及其含有的关系 ##

#删除Liz节点及其含有的关系
    MATCH (n) WHERE id(n) = 13422 DETACH DELETE n

效果：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 4]  
删除所有的节点和关系：

MATCH (n) DETACH DELETE n

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center]: /images/20210505/adcb2e37bcb044969cf42d1582ad6f0d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20210505/3c0850afa9104f1e8a88f11dfab74d5d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20210505/9fedfce5a5364329afbbb7825c6dad24.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20210505/abf6c71f1e0a48a6b7b88a7bd44f2fc5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTAyNTM2Mg_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20210505/c0bd154fdffb4fd8ab9001a4172a581b.png