17,086
社区成员
发帖
与我相关
我的任务
分享insert 和 update
现在要对一个大表中数据进行如下操作
按area_code分区,user_no 是分区索引
当user_no在表中已经存在时,update某些列信息,否则insert该用户信息.
有什么好办法吗?
按area_code分区,user_no 是分区索引
当user_no在表中已经存在时,update某些列信息,否则insert该用户信息.
有什么好办法吗?
...全文
请发表友善的回复…
发表回复
feifeiniao 2003-09-28
- 打赏
- 举报
8i 不支持 merge into 吧.
hdkkk 2003-09-28
- 打赏
- 举报
使用merge语句。具体的
MERGE INTO bonuses D
USING (SELECT employee_id, salary, department_id FROM employees
WHERE department_id = 80) S
ON (D.employee_id = S.employee_id)
WHEN MATCHED THEN UPDATE SET D.bonus = D.bonus + S.salary*.01
WHEN NOT MATCHED THEN INSERT (D.employee_id, D.bonus)
VALUES (S.employee_id, S.salary*0.1);
MERGE INTO bonuses D
USING (SELECT employee_id, salary, department_id FROM employees
WHERE department_id = 80) S
ON (D.employee_id = S.employee_id)
WHEN MATCHED THEN UPDATE SET D.bonus = D.bonus + S.salary*.01
WHEN NOT MATCHED THEN INSERT (D.employee_id, D.bonus)
VALUES (S.employee_id, S.salary*0.1);
