update求助

KaIIYa

kider 发表于 2015-8-3 18:41
别呀，谁都有疏忽的时候。

kider 对于这个问题，我这样写

update t_two set t_two.address = (select t_three.address from t_three where t_three.id=t_two.id);

和

update t_two,t_three set t_two.address=t_three.address where t_two.id=t_three.id;

这两种写法不同点在哪？推荐用哪种写法，大神能稍微解释下么？