mysql判断存在更新，不存在插入

if EXISTS(SELECT id FROM owner_info r WHERE r.housing_info =new.housing_info)
THEN
update owner_info
set region_id=new.region_id,
where housing_info=new.housing_info;
else
INSERT INTO owner_info(
region_id,
project_name,
) VALUES(
new.region_id,
new.project_name,
);
END if

if not exists 即如果不存在，if exists 即如果存在