Analyze the difference between Mysql and Oracle update _mysql

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