修改密码

请输入密码
请输入密码 请输入8-64长度密码 和 email 地址不相同 至少包括数字、大写字母、小写字母、半角符号中的 3 个
请输入密码
提交

修改昵称

当前昵称:
提交

申请证书

证书详情

Please complete this required field.

  • Ultipa Graph V4

Standalone

Please complete this required field.

Please complete this required field.

服务器的MAC地址

Please complete this required field.

Please complete this required field.

取消
申请
ID
产品
状态
核数
申请天数
审批时间
过期时间
MAC地址
申请理由
审核信息
关闭
基础信息
  • 用户昵称:
  • 手机号:
  • 公司名称:
  • 公司邮箱:
  • 地区:
  • 语言:
修改密码
申请证书

当前未申请证书.

申请证书
Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File

No Invoice

v5.0
搜索
    v5.0

      SET

      概述

      SET语句用于更新或删除点、边的属性值。使用前,需先使用MATCH语句获取待修改的点、边数据。

      注意:点、边的Schema(标签)无法修改。它们的系统属性(_id_uuid_from_to_from_uuid_to_uuid)也无法修改。

      <set statement> ::=
        "SET" <set item> [ { "," <set item> }... ]
      
      <set item> ::= 
        <set single property> | <set all properties>
        
      <set single property> ::=
        <graph element variable reference> "." <property name> "=" <value expression>
      
      <set all properties> ::=
        <graph element variable reference> "=" <property specification>
      

      详情

      • 允许修改单个属性(例如,SET n.age = 12age值更新为12,其他属性值不变),或覆盖全部属性(例如,SET n = {age: 12}age值更新为12,其他属性值被删除)。

      示例图

      CREATE GRAPH myGraph { 
        NODE User ({name string, gender string}),
        NODE Club (),
        EDGE Follows ()-[{createdOn datetime, weight int32}]->(),
        EDGE Joins ()-[{memberNo uint32}]->()
      } PARTITION BY HASH(Crc32) SHARDS [1]
      

      INSERT (rowlock:User {_id: "U01", name: "rowlock"}),
             (brainy:User {_id: "U02", name: "Brainy", gender: "male"}),
             (purplechalk:User {_id: "U03", name: "purplechalk", gender: "female"}),
             (mochaeach:User {_id: "U04", name: "mochaeach", gender: "female"}),
             (c:Club {_id: "C01"}),
             (rowlock)-[:Follows {createdOn: "2024-1-5"}]->(brainy),
             (purplechalk)-[:Follows {createdOn: "2024-2-1"}]->(brainy),
             (mochaeach)-[:Follows {createdOn: "2024-2-10"}]->(brainy),
             (brainy)-[:Joins {memberNo: 1}]->(c)
      

      更新属性

      获取点n并更新其属性gender,获取边e并更新其属性createdOn

      MATCH (n:User {name: 'rowlock'})-[e:Follows]->(:User {name: 'Brainy'})
      SET n.gender = 'male', e.createdOn = '2024-1-7'
      RETURN n.gender, e.createdOn
      

      结果:

      n.gender e.createdOn
      male 2024-01-07 00:00:00

      删除属性

      获取点n并删除属性gender的值:

      MATCH (n:User {name: 'mochaeach'})
      SET n.gender = null
      RETURN n
      

      Result: n

      _id _uuid schema
      values
      U04 Sys-gen User {name: "mochaeach", gender: null}

      覆盖所有属性

      获取点n并覆盖其全部属性,更新属性name并删除所有其他属性值:

      MATCH (n:User {name: 'purplechalk'})
      SET n = {name: 'MasterSwift'}
      RETURN n
      

      结果:n

      _id _uuid schema
      values
      U03 Sys-gen User {name: "MasterSwift", gender: null}

      删除所有属性

      获取点n并删除其全部属性值:

      MATCH (n:User {name: 'rowlock'})
      SET n = {}
      RETURN n
      

      结果:n

      _id _uuid schema
      values
      U03 Sys-gen User {name: null, gender: null}

      使用CASE更新属性

      根据Follows边的createdOn属性值,指定其weight属性值:

      MATCH ()-[e:Follows]->()
      SET e.weight = CASE
        WHEN e.createdOn < '2024-1-31' THEN 10
        ELSE 8
      END
      RETURN e
      

      结果:e

      _uuid
      _from
      _to
      _from_uuid
      _to_uuid
      schema
      values
      Sys-gen U01 U02 UUID of U01 UUID of U02 Follows {createdOn: "2024-01-05 00:00:00", weight: 10}
      Sys-gen U04 U02 UUID of U04 UUID of U02 Follows {createdOn: "2024-02-10 00:00:00", weight: 8}
      Sys-gen U03 U02 UUID of U03 UUID of U02 Follows {createdOn: "2024-02-01 00:00:00", weight: 8}

      值类型不符

      如果提供的值与属性值类型不同并且无法转换,将使用该属性值类型的默认值作为新值。

      将边属性memberNoint32类型)更新为一个字符串:

      MATCH ()-[e:Joins]->()
      SET e.memberNo = 'm2'
      RETURN e
      

      结果:e

      _uuid
      _from
      _to
      _from_uuid
      _to_uuid
      schema
      values
      Sys-gen C01 U02 UUID of C01 UUID of U02 Follows {memberNo: 0}
      请完成以下信息后可下载此书
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写