MySQL from a Table update field to another table _mysql

Let's start with a few simple examples

Solution 1:1 Columns

Update student S, City C
  Set s.city_name = C.name
 where s.city_code = C.code;

Solution 2: Multiple columns

Update A, b 

set A.title=b.title, A.name=b.name
where a.id=b.id

Solution 3: Subquery

Update student S Set city_name = (select name from city where code = S.city_code);

Let's take a look at a few more.

For example, to update the field of a table Tk_zyt_scenery_order to T_advs_order, you might generally write this:

UPDATE t_advs_order SET
 
 attribute1= (SELECT o.order_state from Tk_zyt_scenery_order o WHERE o.order_id= ' on '),
 
 attribute2= (select O.order_state from Tk_zyt_scenery_order o where o.order_id= ' on ')
 
 where EXISTS (select O.order_ State from Tk_zyt_scenery_order o WHERE o.order_id= ' on ');

This efficiency is relatively low, optimized writing:

UPDATE T_advs_order a INNER JOIN tk_zyt_scenery_order s on s.order_id=a. ' On ' SET
 
 a.attribute1=s.order_id,
 
 a.attribute2=s.order_id;