Mysql Replace into 与oracle的 merge

当一条记录 在数据库中存在进行更新，否则进行插入的时候
oralce 中可以通过merge

merge into AB_TABLE t1
using (select SHORTPN, HSCODE, LONGNAME, NAMECN from A_TABLE) t2
on (t1.SHORTPN = t2.SHORTPN)
when matched then
     update set t1.HSCODE = t2.HSCODE, t1.LONGNAME = t2.LONGNAME, t1.NAMECN = t2.NAMECN
when not matched then
     insert (SHORTPN, HSCODE,LONGNAME,SHORTNAME,NAMECN,DECLARE_CRITERION,REMARK,DATEUPDATED) values (t2.SHORTPN, t2.HSCODE, t2.LONGNAME, null, t2.NAMECN, null, null, null);
commit;

那么在mysql中 可以通过 repalce into

replace into 
	EX_ENERGY_CO_INFO(主键1,主键2,主键3,主键4,VALUE1,VALUE2,VALUE3,VALUE4) 
SELECT 'BC0108','LC0208','G','ED0008','1','2','3','4'

PS 由于我这是4个主键。
注意mysql中 会根据主键或者是索引去判断