update show128 set explist = (select explist from show128tmp where (唯一条件))
不好意思,没写清楚,别人问的问题,我觉得不行:(2001-11-08 16:40:28) 朱朱 show128,show128tmp结构同。 s1 varchar(6),s2 varchar(8),s3 decimal(8,3) 按show128tmp修改show128update show128 set s2=show128tmp.s2,s3=show128tmp.s3 where s1=show128tmp.s1该语句对吗?
不对,改为 update show128 set s2=show128tmp.s2,s3=show128tmp.s3 from show128,show128tmp where show128.s1=show128tmp.s1
update show128 x set (s2,s3) = (select s2,s3 from show128tmp y where y.s1=x.s1);
update show128 set s2=show128tmp.s2,s3=show128tmp.s3 where s1=show128tmp.s1UPDATE show128 SET s2=show128tmp.s2,s3=show128tmp.s3 FROM show128 INNER JOIN show128temp ON show128.s1=show128tmp.s1
show128,show128tmp结构同。
s1 varchar(6),s2 varchar(8),s3 decimal(8,3)
按show128tmp修改show128update show128 set s2=show128tmp.s2,s3=show128tmp.s3 where s1=show128tmp.s1该语句对吗?
update show128 set s2=show128tmp.s2,s3=show128tmp.s3
from show128,show128tmp
where show128.s1=show128tmp.s1
set (s2,s3) = (select s2,s3 from show128tmp y
where y.s1=x.s1);
SET s2=show128tmp.s2,s3=show128tmp.s3
FROM show128 INNER JOIN show128temp ON show128.s1=show128tmp.s1