ref: from SOF UPDATE tableB t1 INNER JOIN tableA t2 ON t1.id = t2.id SET t1.name = t2.name Post navigation SQL check duplicate Tell another server to run a shell script