ORACLE更新数据时如果有就更新没有就插入
a表字段有user_id,status,heart_time三个字段b代表临时数据表,将要比较的值作为b的user_id参数, ON (a.user_id = b.user_id)是比较,后面两句话是两条选择MERGE INTO 表名 aUSING (SELECT 参数值 as user_idFROM dual) bON (a.user_id = b.user_id)WHEN...
原创
2018-11-13 13:49:13 ·
1985 阅读 ·
0 评论