网站建议:179001057@qq.com

mysql与Oracle update的区别

技术2022-05-11  0

update :单表的更新不用说了,两者一样,主要说说多表的更新

   

       Oracle> Oracle的多表更新要求比较严格,所以有的时候不是很好写,我们可以试试Oracle的游标

                    (游标参考:http://blog.csdn.net/lovelyhermione/archive/2009/08/18/4457500.aspx)

          update (

                   select t.charger_id_ new_charger_id_

                   from t_cus_year_status t

                   left join t_customer_infos cus on cus.id_ = t.cus_id_

                   where....

        ) n  set  n.new_charger_id_ =6;

   

     mysql>

                   update t_cus_year_status t

                     left join t_customer_infos cus on cus.id_ = t.cus_id_

                   set t.charger_id_  =6

                   where......;


最新回复(0)