MySQL关联UPDATE语句
UPDATE A,B SET A.c1=B.c1,A.c2=B.c2 WHERE A.id=B.id
UPDATE A INNER JOIN B ON A.id=B.id SET A.c1=B.c1,A.c2=B.c2 WHERE...
关联更新
最新推荐文章于 2024-05-15 11:12:59 发布
MySQL关联UPDATE语句
UPDATE A,B SET A.c1=B.c1,A.c2=B.c2 WHERE A.id=B.id
UPDATE A INNER JOIN B ON A.id=B.id SET A.c1=B.c1,A.c2=B.c2 WHERE...