您所在位置：主题：新手请教
yk001
[专家分：0] 发布于 2005-09-29 12:27:00
如何使得以下两条语句没3秒执行一次
insert into xt_tf_temp select dhhm,czlx,clzt from xt_tf where clzt='0' or clzt='2';
commit;
update xt_tf set clzt='1' where clzt='0' or clzt='2' and dhhm in (select dhhm from xt_tf_temp);
commit;
insert into xt_tf_temp select dhhm,czlx,clzt from xt_tf where clzt='0' or clzt='2';
commit;
update xt_tf set clzt='1' where clzt='0' or clzt='2' and dhhm in (select dhhm from xt_tf_temp);
commit;
