JOIN适用于一切联合表操作,包括select/update/delete。 select用法:http://www.mysqltutorial.org/mysql-join/ update用法:http://www.mysqltutorial.org/mysql-update-join/ delete用法:http://www.mysqltutorial.org/mysql-delete-join/