mysql多表join时候update更新数据的方法

sql语句: 代码如下:update item i,resource_library r,resource_review_link l set i.name=CONCAT(‘Review:’,r.resource_name) where i.item_id=l.instance_id and l.level=’item’ and r.resource_id=l.resource_id and i.name=” JOIN UPDATE & JOIN DELETE 代码如下: update a set a.schoolname = b.schoolname from tb_Std as a jo