菜单

批量更新插入(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 参数名解析;

最近修改: 2025-12-05