更新文档 #

UPDATE <class>|RID|<query> 
SET <field> = <value>[, <field> = <value>]*
[WHERE <condition>]
[RETURN <return-spec>]

UPDATE <class>|RID|<query> 
ADD <field> = <value>[, <field> = <value>]*
[WHERE <condition>]

UPDATE <class>|RID|<query> 
REMOVE <field>[, <field>]* | <field> = <value>
[WHERE <condition>]

UPDATE特点：
├── 支持条件更新
├── 支持原子操作
├── 支持批量更新
├── 支持UPSERT模式
└── 返回更新结果

UPDATE Person SET name = 'Tom Hanks' WHERE name = 'Tom'

UPDATE Person SET 
    name = 'Tom Hanks',
    age = 31,
    city = 'Shanghai'
WHERE @rid = #12:0

UPDATE #12:0 SET name = 'Tom Hanks', age = 31

UPDATE Person SET age = age + 1 WHERE name = 'Tom' RETURN AFTER @rid, name, age
UPDATE Person SET age = age + 1 WHERE name = 'Tom' RETURN AFTER @this

UPDATE Person SET age = age + 1 WHERE name = 'Tom' 
RETURN BEFORE @rid, BEFORE age AS oldAge, AFTER age AS newAge

UPDATE Person SET status = 'inactive' WHERE age > 60
UPDATE Person SET level = 'senior' WHERE age >= 60 AND yearsOfService >= 20
UPDATE Person SET status = 'verified' WHERE email LIKE '%@company.com'

UPDATE Person SET status = 'active' WHERE @rid IN [#12:0, #12:1, #12:2]
UPDATE Person SET department = 'IT' WHERE name IN ['Tom', 'Jerry', 'Mike']

UPDATE Person SET bonus = 1000 
WHERE @rid IN (SELECT @rid FROM Person WHERE performance = 'excellent')

UPDATE Person SET status = 'employee' 
WHERE employer = (SELECT FROM Company WHERE name = 'ABC Corp')

UPDATE Person SET age = age + 1 WHERE name = 'Tom'
UPDATE Product SET stock = stock - 1 WHERE @rid = #15:0
UPDATE Account SET balance = balance + 100.00 WHERE accountId = 'A001'

UPDATE Product SET price = price * 1.1 WHERE category = 'electronics'
UPDATE Person SET score = score * 2 + bonus WHERE status = 'active'

UPDATE Person SET level = 
    CASE 
        WHEN age < 18 THEN 'junior'
        WHEN age < 60 THEN 'senior'
        ELSE 'expert'
    END

UPDATE Person SET status = IF(score >= 60, 'pass', 'fail') WHERE examId = 'E001'

UPDATE Person ADD hobbies = 'swimming' WHERE name = 'Tom'
UPDATE Person ADD tags = 'expert' WHERE @rid = #12:0

UPDATE Person REMOVE hobbies = 'gaming' WHERE name = 'Tom'
UPDATE Person REMOVE tags = 'beginner' WHERE @rid = #12:0

UPDATE Person SET hobbies = ['reading', 'coding', 'swimming'] WHERE name = 'Tom'
UPDATE Person SET tags = {'developer', 'expert', 'mentor'} WHERE @rid = #12:0

UPDATE Person PUT preferences = 'fontSize', 'large' WHERE name = 'Tom'
UPDATE Person REMOVE preferences['timezone'] WHERE name = 'Tom'
UPDATE Person SET preferences = {'theme': 'dark', 'language': 'en'} WHERE name = 'Tom'

UPDATE Person SET hobbies = hobbies || ['swimming', 'hiking'] WHERE name = 'Tom'

UPDATE Person SET employer = (SELECT FROM Company WHERE name = 'ABC Corp') WHERE name = 'Tom'

UPDATE Person ADD friends = (SELECT FROM Person WHERE name = 'Jerry') WHERE name = 'Tom'

UPDATE Person REMOVE friends = (SELECT FROM Person WHERE name = 'Mike') WHERE name = 'Tom'

UPDATE Person SET employer = (SELECT FROM Company WHERE name = 'ABC Corp') 
WHERE employer IS NULL

UPDATE Person SET name = 'Tom', age = 30 UPSERT WHERE email = 'tom@example.com'

UPDATE Person SET 
    name = 'Tom',
    age = 30,
    updatedAt = sysdate()
UPSERT 
WHERE email = 'tom@example.com'

UPDATE Person SET name = 'Tom' UPSERT WHERE email = 'tom@example.com' RETURN @rid, @version

UPDATE Person SET status = 'active'

UPDATE Person SET status = 'processed' LIMIT 100

LET batch = SELECT FROM Person WHERE status = 'pending' LIMIT 100;
UPDATE $batch SET status = 'processed'

LET updates = [
    {'rid': #12:0, 'name': 'Tom'},
    {'rid': #12:1, 'name': 'Jerry'},
    {'rid': #12:2, 'name': 'Mike'}
]
FOREACH ($item IN $updates) {
    UPDATE $item.rid SET name = $item.name
}

UPDATE Person SET name = 'Tom Hanks', age = 31 WHERE @rid = #12:0

UPDATE KNOWS SET since = 2021, level = 'close' WHERE @rid = #25:0

UPDATE KNOWS SET active = true WHERE out.name = 'Tom' AND in.name = 'Jerry'

BEGIN
UPDATE Account SET balance = balance - 100 WHERE id = 'A001'
UPDATE Account SET balance = balance + 100 WHERE id = 'A002'
INSERT INTO Transaction SET fromAccount = 'A001', toAccount = 'A002', amount = 100
COMMIT

BEGIN
LET account = SELECT FROM Account WHERE id = 'A001'
IF ($account[0].balance >= 100) {
    UPDATE Account SET balance = balance - 100 WHERE id = 'A001'
    UPDATE Account SET balance = balance + 100 WHERE id = 'A002'
    COMMIT
} ELSE {
    ROLLBACK
    SELECT 'Insufficient balance' AS error
}

SELECT @rid, @version FROM Person WHERE name = 'Tom'

UPDATE Person SET name = 'Tom Hanks' WHERE @rid = #12:0 AND @version = 5

TRY {
    UPDATE Person SET name = 'Tom Hanks' WHERE @rid = #12:0 AND @version = 5
} CATCH {
    SELECT 'Version conflict, please retry' AS error
}

CREATE INDEX Person.email UNIQUE
UPDATE Person SET status = 'active' WHERE email = 'tom@example.com'

BEGIN
UPDATE Person SET status = 'active' WHERE status = 'pending' LIMIT 1000
COMMIT

UPDATE Person SET status = 'active' WHERE status = 'inactive'

UPDATE User SET 
    firstName = 'Tom',
    lastName = 'Hanks',
    email = 'tom.hanks@example.com',
    updatedAt = sysdate()
WHERE id = 'user_001'
RETURN AFTER @rid, firstName, lastName, email

UPDATE Product SET 
    stock = stock - 1,
    updatedAt = sysdate()
WHERE id = 'prod_001' AND stock > 0
RETURN AFTER @rid, stock

UPDATE Order SET 
    status = 'shipped',
    shippedAt = sysdate(),
    updatedAt = sysdate()
WHERE id = 'order_001' AND status = 'paid'
RETURN AFTER @rid, status

UPDATE Log SET archived = true 
WHERE createdAt < sysdate() - 30 AND archived = false
LIMIT 10000

UPDATE Counter SET value = value + 1 WHERE name = 'page_views'
UPDATE User SET loginCount = loginCount + 1, lastLoginAt = sysdate() WHERE id = 'user_001'

常见错误：
├── 记录不存在
├── 版本冲突
├── 违反约束
├── 类型不匹配
└── 权限不足

TRY {
    UPDATE Person SET name = 'Tom' WHERE @rid = #12:0
} CATCH {
    SELECT 'Update failed: ' + $error AS message
}