mysqlマルチ外部フィールドの更新
148 ワード
# a name,phone b name,phone
update tempb b inner join tempa a set b.name = a.name,b.phone=a.phone where b.uid = a.id
# a name,phone b name,phone
update tempb b inner join tempa a set b.name = a.name,b.phone=a.phone where b.uid = a.id