摘要: UPDATE table1 t1 SET (name, desc) = (SELECT t2.name, t2.desc FROM table2 t2 WHERE t1.id = t2.id) WHERE EXISTS ( SELECT 1 FROM table2 t2 ... 阅读全文
posted @ 2018-08-21 14:59 kakaisgood 阅读(502) 评论(0) 推荐(0)