业余需求有时候会更新一张表的数据,从另外一张表的字段来
贴上代码
MERGE INTO t_hog_product_models_test te
USING (SELECT modelno, price FROM tmp_price) tp
ON (tp.modelno = te.model_no)
WHEN MATCHED THEN
UPDATE SET te.price_info_cn = tp.price;
业余需求有时候会更新一张表的数据,从另外一张表的字段来
贴上代码
MERGE INTO t_hog_product_models_test te
USING (SELECT modelno, price FROM tmp_price) tp
ON (tp.modelno = te.model_no)
WHEN MATCHED THEN
UPDATE SET te.price_info_cn = tp.price;