insert or update sql

-- adb应用例子，如果字段设置出现is not null 则需要将其也加入到更新字段中
INSERT INTO order_info (
	order_info_id
	,order_info_name)
select io.order_info_id,io.order_info_name 
from order_info_other io 
-- 若关联其他表可能必须要带一个where条件才行，不然会报错
where order_info_name is null
ON DUPLICATE KEY UPDATE
order_info_id = order_info_id, 
order_info_name = order_info_name

-- holo应用例子
INSERT INTO ods.order_info(
        order_info_id
        ,order_info_name)
select   order_info_id
        ,order_info_name
from order_info_other io 
ON      conflict(order_info_id)
DO UPDATE SET (order_info_name) = ROW(excluded. * );