weixin_39259170的博客

原创 mysql实现merge into的方法

mysql实现merge into的方法merge into语法merge语法：MERGE INTO [target-table] A USING [source-table sql] B ON([conditional expression] and [...]...) WHEN MATCHED THEN [UPDATE sql] WHEN NOT MATCHED THEN [INSERT sql]初始化数据#实例：–oracle与mysql数据初始化create table PR