orcale命令
update project_main b set b.KHNR =(select khzb from test_lsd a where a.id=b.xmid ) --將a表的khzb 的值更新到b表khnr中,條件是a.id=b.xmid
create table project_main_bak as select * from project_main --創建project_main表的備份表
update project_main b set b.KHNR =(select khzb from test_lsd a where a.id=b.xmid ) --將a表的khzb 的值更新到b表khnr中,條件是a.id=b.xmid
create table project_main_bak as select * from project_main --創建project_main表的備份表