update table1 a set a.ziduan = (select b.newziduan from table2 b where b.id = a.id)
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/229003.html原文链接:https://javaforall.net
update语句多表关联updatetable1 ziduan selectb newziduanfro id b id
update table1 a set a.ziduan = (select b.newziduan from table2 b where b.id = a.id)
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/229003.html原文链接:https://javaforall.net