MYSQL关联表更新

UPDATE t1 AS a JOIN t2 AS b ON a.c1 = b.c1 SET a.t2 = b.t2

posted @ 2022-09-30 14:56  237237  阅读(15)  评论(0)    收藏  举报