使用select更新MYSQL - MYSQL Update with a select

MYSQL Update with a select

本文关键字：MYSQL 更新 select 使用 | 更新日期: 2023-09-27

我想从另一个表值更新一个值，这是我的代码

UPDATE 
ag_personal_information 
SET
ag_personal_information.ag_zone_id = 
  (SELECT ag_officer_service_information.ag_zone_id 
                  FROM ag_officer_service_information) 
WHERE
ag_officer_service_information.ag_zone_id <> ag_personal_information.ag_zone_id

尝试这个

UPDATE ag_personal_information AS A 
SET ag_personal_information.ag_zone_id = (
            SELECT ag_officer_service_information.ag_zone_id 
            FROM ag_officer_service_information AS B 
            WHERE A.ag_officer_service_information.ag_zone_id <> B.ag_personal_information.ag_zone_id)

将=置于ag_officer_service_information.ag_zone_id和ag_personal_information.ag_zone_id 之间

 UPDATE ag_personal_information 
     SET ag_personal_information.ag_zone_id =
    (SELECT ag_officer_service_information.ag_zone_id FROM ag_officer_service_information) 
     WHERE ag_officer_service_information.ag_zone_id = ag_personal_information.ag_zone_id