sql数据库表修改。。。

[caiyuan922]

多表修改。。。
upedate * set 列名
where
又一张表。。。要把这张表的三列和修改表的三列连接起来。。。把这三列的值给修改表。。。
谁会代码？急。。。

[黄_瓜]

[Quote=引用楼主 caiyuan922 的回复:]
多表修改。。。
upedate * set 列名
where又一张表。。。要把这张表的三列和修改表的三列连接起来。。。把这三列的值给修改表。。。
谁会代码？急。。。
[/Quote]

--没明白你的意思
--基本语法
update student(表名) set num(列名)="13"  where name="小A" 

[caiyuan922]

[Quote=引用 1 楼 beirut 的回复:]
引用楼主 caiyuan922 的回复:
多表修改。。。
upedate * set 列名
where又一张表。。。要把这张表的三列和修改表的三列连接起来。。。把这三列的值给修改表。。。
谁会代码？急。。。

SQL code--没明白你的意思
--基本语法update student(表名)set num(列名)="13"where name="小A"
[/Quote]


我点错了就给你分分数了。晕。。。。
我也会基本语法。就是两个表连接。吧一个表上的值传给要修改的表

[caiyuan922]

[Quote=引用楼主 caiyuan922 的回复:]
多表修改。。。
upedate * set 列名
where
又一张表。。。要把这张表的三列和修改表的三列连接起来。。。把这三列的值给修改表。。。
谁会代码？急。。。
[/Quote]




列名一样，单值不一样。。。把要列一个表的三列的值给要修改的表的三列。。。

[xiequan2]

try
update t1 set t1.a=t2.a,t1.b=t2.b,t1.c=t2.c from tb t1 ,t t2 where t1.id=t2.id

[caiyuan922]

[Quote=引用 4 楼 xiequan2 的回复:]
SQL codetryupdate t1set t1.a=t2.a,t1.b=t2.b,t1.c=t2.cfrom tb t1 ,t t2where t1.id=t2.id
[/Quote]



谢谢。。。。
insert into RFix_List1(RFix_Num,RFix_PCNum,RFix_MenDate,RFix_UpDate,RFix_Examine,RFix_Counterman,RFix_Found,RFix_Depar,RFix_BiaoShi,RFix_WanCheng,RFix_Remark)
select RFix_Num,RFix_PCNum,RFix_MenDate,RFix_UpDate,RFix_Examine,RFix_Counterman,RFix_Found,RFix_Depar,RFix_BiaoShi,RFix_WanCheng,RFix_Remark
from RFix_List



insert into RFix_View1(RFix_Grid_Num,RFix_Grid_ProNum,RFix_Grid_Amount,RFix_Grid_GoodsNum,RFix_Grid_yuanying,RFix_Grid_Remark)
select RFix_Grid_Num,RFix_Grid_ProNum,RFix_Grid_Amount,RFix_Grid_GoodsNum,RFix_Grid_yuanying,RFix_Grid_Remark
from RFix_View


insert into RFix_JieDan1(RFix_JieDan_Num,RFix_JieDan_ProNum,RFix_JieDan_GoodsNum,RFix_JieDan_Date,RFix_JieDan_BiaoShi)
select RFix_JieDan_Num,RFix_JieDan_ProNum,RFix_JieDan_GoodsNum,RFix_JieDan_Date,RFix_JieDan_BiaoShi
from RFix_JieDan

update RFix_JieDan1
set RFix_JieDan_WanCheng=1
where RFix_JieDan_ID in (
select distinct RFix_JieDan_ID
from RFix_JieDan1,RFix_Clear
where RFix_JieDan1.RFix_JieDan_Num=RFix_Clear.Clear_Num
and RFix_JieDan1.RFix_JieDan_ProNum=RFix_Clear.Clear_ProNum
and RFix_JieDan1.RFix_JieDan_GoodsNum=RFix_Clear.Clear_Proid
and Clear_BiaoShi=1)





insert into RFix_Clear1(Clear_Num,Clear_ProNum,Clear_ProNum2,Clear_Amount,Clear_Proid,Clear_Sprice,Clear_EmpNum,Clear_Remark,Clear_NOXiu)
select Clear_Num,Clear_ProNum,Clear_ProNum2,Clear_Amount,Clear_Proid,Clear_Sprice,Clear_EmpNum,Clear_Remark,Clear_NOXiu
from RFix_Clear
where Clear_NOXiu=0

insert into RFix_Clear1(Clear_Num,Clear_ProNum,Clear_Amount,Clear_Proid,Clear_Sprice,Clear_EmpNum,Clear_Remark,Clear_NOXiu)
select Clear_Num,Clear_ProNum,Clear_Amount,Clear_Proid,Clear_Sprice,Clear_EmpNum,Clear_Remark,Clear_NOXiu
from RFix_Clear
where Clear_NOXiu=1



update RFix_Clear1
set Clear_ProNum2='CP00068',
Clear_EmpNum='0035'
where Clear_NOXiu=1