UPDATE a, b set a.domain_id = b.id WHERE a.business_name = b.business_name
UPDATE a join b on a.business_name = b.business_name set a.domain_id = b.id
UPDATE a set a.domain_id = (SELECT b.id from b WHERE a.business_name = b.business_name)
业务时候用到了，做个记录。
已经进行了脱敏。
SQL系统不给过带子查询的，应该选择第二个Join来进行更改
