摘要: 1,update from 关联表的更新 update table a set name=b.name from table B b where a.id=b.id; update test set info=tmp.info from (values (1,'new1'),(2,'new2'),( 阅读全文
posted @ 2018-07-19 15:17 M_Y_522 阅读(6678) 评论(0) 推荐(0) 编辑