9 lines
267 B
Go
9 lines
267 B
Go
|
UPDATE "player_info"
|
|||
|
|
SET data = jsonb_set(
|
|||
|
|
data,
|
|||
|
|
'{exp_pool}',
|
|||
|
|
-- 直接复用查询中的计算逻辑，确保结果一致
|
|||
|
|
to_jsonb(COALESCE((data->>'exp_pool')::int, 0) + 50000000),
|
|||
|
|
true -- 字段不存在时自动初始化为10
|
|||
|
|
)
|
|||
|
|
WHERE player_id = 10001;
|