[SQL]update的时候进行select的三种写法

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来进行更改

版权声明：本文为pmdream原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。