ps:小小的记录一下Mysql中的联表更新语句,遇到别的再回来补充
使用inner jion联表查询
UPDATE copy2 t2
INNER JOIN copy AS t1 ON t1.ip = t2.ip
SET t2.b = t1.a
ps:小小的记录一下Mysql中的联表更新语句,遇到别的再回来补充
使用inner jion联表查询
UPDATE copy2 t2
INNER JOIN copy AS t1 ON t1.ip = t2.ip
SET t2.b = t1.a