mysql

1、更新update 两张表关联表更新

UPDATE t_sys_org
INNER JOIN data_transform_center.client c
on c.org_ids=t_sys_org.id
SET t_sys_org.NAME = c.NAME