示例一
UPDATE t1 a, t2 b SET b.xm8='小明zj' WHERE a.xm14='浙江' and b.xm8='小明'
示例二
UPDATE t1 a, t2 b SET b.xm8=a.xm6 WHERE a.id=b.xm8
11-25
2024
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-17
10万+
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
示例一
UPDATE t1 a, t2 b SET b.xm8='小明zj' WHERE a.xm14='浙江' and b.xm8='小明'
示例二
UPDATE t1 a, t2 b SET b.xm8=a.xm6 WHERE a.id=b.xm8