Differences between mysql and Oracle update

Update: it is unnecessary to update a single table. The two are the same, mainly about updating multiple tables.
Copy codeThe Code is as follows:
Oracle> Oracle has strict requirements for multi-Table update, so sometimes it is not very easy to write. We can try Oracle's cursor
Update (
Select t. charger_id _ new_charger_id _
From t_cus_year_status t
Left join t_customer_infos cuus on cus. id _ = t. cus_id _
Where ....
) N set n. new_charger_id _ = 6;


Copy codeThe Code is as follows:
Mysql>
Update t_cus_year_status t
Left join t_customer_infos cuus on cus. id _ = t. cus_id _
Set t. charger_id _ = 6
Where ......;