select * from xiaolin2
for update
delete xiaolin2
drop table xiaolin2
create table xiaolin2 (
liao2 varchar(100) not null,
quy number(20,6)
);
select ima01,ima531 from ima_file where ima01 in (select liao2 from xiaolin2 )
for update
update ima_file set ima531=(select quy from xiaolin2 where ima01=liao2) where ima01 in (select liao2 from xiaolin2 )
市价导入
最新推荐文章于 2013-01-16 08:03:44 发布