You can‘t specify target table ‘XXX‘ for update in FROM clause

UPDATE xxx_department 
SET rank = '2'  
WHERE aaa_id in (SELECT id FROM xxx_department WHERE aaa_id IS NULL) ;

UPDATE xxx_department 
SET rank = '2'  
WHERE aaa_id in 
 (SELECT * FROM (SELECT id FROM xxx_department WHERE aaa_id IS NULL) a );

-- sql 原写法:
 
   update x set xxx_xxrial_id = null where id not in 
    (select id from x where ccc_info = 1);

 
-- 使用 left join 改写为自链接方式:

    update x left join
       x a
       on x.id = a.id and a.ccc_info = 1
    set xxx_xxrial_id = null
    where a.id is null;