update a set a.name1 = b.name1, a.name2=b.name2from 表A a, 表B b where a.id=b.id 转载于:https://www.cnblogs.com/tiandi/p/5016283.html