Oracle写法:
update temp_agentpay_df q set q.up_batch_bizid=(select c.batch_bizid from temp_df_id c where c.detail_id=q.detail_id) ;
Mysql写法:
update temp_agentpay_df q,temp_df_id c set q.up_batch_bizid=c.batch_bizid where c.detail_id=q.detail_id;
Oracle写法:
update temp_agentpay_df q set q.up_batch_bizid=(select c.batch_bizid from temp_df_id c where c.detail_id=q.detail_id) ;
Mysql写法:
update temp_agentpay_df q,temp_df_id c set q.up_batch_bizid=c.batch_bizid where c.detail_id=q.detail_id;
转载于:https://www.cnblogs.com/xibuhaohao/p/10253819.html