PHP Share (36) MySQL related table update

One: Associating different table updates

1: Update via where association

Update Set = c.name  where=

2: Sub-query update

Update Set = (Selectfromwhere=

Sub-query Update optimizations:

UPDATET_advs_orderSETattribute1=(SELECTO.order_state fromTk_zyt_scenery_order oWHEREo.order_id=` on'), Attribute2=(SELECTO.order_state fromTk_zyt_scenery_order oWHEREo.order_id=` on`)     WHERE EXISTS(SELECTO.order_state fromTk_zyt_scenery_order oWHEREo.order_id=` on`);

Into

UPDATE
INNER JOIN  on s.order_id=A. ' on
SET    
A.attribute1=s.order_id,     
A.attribute2=

PHP Share (36) MySQL related table update