> ## Documentation Index
> Fetch the complete documentation index at: https://rpa.bazhuayu.com/helpcenter/llms.txt
> Use this file to discover all available pages before exploring further.

# 批量更新插入(batch_upsert)

示例：INSERT INTO `user_order` (`id`,`order`,`price`,`remark`)
VALUES (1001,'ORD-2025',99.9,NULL),(1002,'ORD-2026',199.9,'测试备注')
ON DUPLICATE KEY UPDATE `id`=VALUES(`id`),`order`=VALUES(`order`),`price`=VALUES(`price`),`remark`=VALUES(`remark`);

INSERT INTO 表名 (参数名)
VALUES 参数值解析
ON DUPLICATE KEY UPDATE 参数名解析;

<img src="https://mintcdn.com/bazhuayu-rpa-docs/_0ncJVuvn2vLb0nP/helpcenter/commands/custom-commands/MtBiYKy9/images/RSo5Gzdx-01.png?fit=max&auto=format&n=_0ncJVuvn2vLb0nP&q=85&s=c4f7a8d8662da66ba1da1ca81915b50c" alt="image" width="986" height="664" data-path="helpcenter/commands/custom-commands/MtBiYKy9/images/RSo5Gzdx-01.png" />

<Info>
  使用指令过程中遇到问题？前往 [八爪鱼RPA 开发者社区问答板块](https://rpa.bazhuayu.com/community/questions) 提问，获取官方与社区帮助。
</Info>