use `dcp`; -- 更新单位英文名 UPDATE base_unit_entity a LEFT JOIN base_unit_info b ON a.id = b.base_entity_id SET a.entity_name = b.unit_name WHERE b.`language` = 'en'