表A和表B,现在希望更新A表,当 A.bid = B.id时,a.x = b.x, a.y=b.y,请问mysql中sql语句
update a inner join b on a.bid=b.id set a.x=b.x,a.y=b.y ;
表A和表B,现在希望更新A表,当 A.bid = B.id时,a.x = b.x, a.y=b.y,请问mysql中sql语句
update a inner join b on a.bid=b.id set a.x=b.x,a.y=b.y ;
转载于:https://www.cnblogs.com/chen-lhx/p/4062263.html