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表的备份表
posted on 2009-07-29 20:23 鲁胜迪 阅读(251) 评论(0) 编辑 收藏
Powered by: BlogJava Copyright © 鲁胜迪