Mysql updates another table through one table, and mysql updates another table

Mysql updates another table through one table, and mysql updates another table
 

In mysql, you can modify the content of another associated table through the columns of one table:

1: Modify 1 column

Update student s, city c set s. city_name = c. name where s. city_code = c. code;

 

2: Modify multiple columns

Update a, B set a. title = B. title, a. name = B. namewhere a. id = B. id

 

3: subquery

Update student s set city_name = (select name from city where code = s. city_code );

 

REF:

Http://dba.stackexchange.com/questions/119621/how-to-update-10-million-rows-in-mysql-single-table-as-fast-as-possible

Http://stackoverflow.com/questions/6393763/fast-cross-table-update-with-mysql

Http://stackoverflow.com/questions/11709043/mysql-update-column-with-value-from-another-table