mysql update from select

1UPDATE t1
2SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
3FROM MY_TABLE AS t1
4INNER JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.ID
5WHERE t1.COL3 = 'OK';

1UPDATE
2    products_description pd INNER JOIN products_description pd2 ON
3    (pd.products_id=pd2.products_id AND pd2.language_id=1 AND pd.language_id<>1)
4SET pd.products_seo = pd2.products_seo;

1UPDATE table_name SET field1 = 'value 1', field2 = 'value 2'
2WHERE field3 = 'value 3'
3

1UPDATE tableName SET columnName = yourValue;
2#to update multiple columns:
3UPDATE tableName SET column1 = value1, column2 = value2; #and so on

1UPDATE tableName SET anAttribute = 'Something' WHERE anOtherAttribute = 'SomethingElse'
2
3//All 'SomethingElse' values will become 'Something'

1UPDATE name_table SET param = 'VALUE';