1、Oracle数据同步数据
语法结构:
MERGE [INTO] [schema.]table [alias]
USING {[schema.]table|views|query} [alias]
ON {condition}
WHEN MATCHED THEN UPDATE SET {clause}
WHEN NOT MATCHED THEN INSERT VALUES {clause}
2、Mysql数据同步数据
语法示例:
INSERT INTO
hgy_reoprt_breakfastbuyrecord (record_id,qid, order_no, `status`,
pay_type,`order_shitang`,`total_price`,uid,company,dept,id_card,user_type,real_name,
phone,order_time,user_level,tradeNo,type,create_time)
SELECT
#{record_id},#{qid},#{order_no},#{status},#{pay_type},#{order_shitang},#{total_price},
#{uid},#{company},#{dept},#{id_card},#{user_type},#{real_name},#{phone},#{order_time},
#{user_level},#{tradeNo},#{type},#{create_time}
FROM dual WHERE NOT
EXISTS(
SELECT 1
FROM hgy_reoprt_breakfastbuyrecord
WHERE qid = #{qid}
);