批量更新postgre数据库
UPDATE tb_sub_task_org_assets_relation
SET update_time = now( ),
exec_detail = tmp.tmp_detail
FROM
(VALUES (‘13’,’{“xxx1”:“xxxx11”}’::json), (‘23’,’{“xxx1”:“xxxx12”}’::json)) as tmp(tmp_uuid, tmp_detail)
WHERE
uuid = tmp.tmp_uuid
postgre数据库单表批量更新
最新推荐文章于 2024-07-15 06:44:37 发布