mysql關聯更新update

update db_operation_log o LEFT JOIN db_user u  ON o.user_id = u.id set o.user_name = u.real_name , o.mobile = u.mobile