Analyzing the difference between MySQL and Oracle update

This article is a detailed analysis of the difference between MySQL and Oracle update, the need for friends under the reference

Update: Tanku Updates Needless to say, the two are the same, mainly talking about the update of multiple tables

Copy Code code as follows:


oracle> Oracle's multiple-table update requirements are more stringent, so sometimes it's not very good to write and we can try Oracle Cursors


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;

Copy Code code as follows:


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 ...;