- UPDATE table_1 t1 left join table_2 t2 on t2.id = t1.tid SET t1.username = t2.uname
- where t1.id>5;
UPDATE `shop_page` t1 LEFT JOIN `shop_list` t2 ON DATE='2018-04-12' SET t1.`company` = t2.`company` WHERE INSTR(t1.`columnName`,t2.`name`)>0 ;
单张表自联,多表关联更新都可以。