修改数据库表名:rename [old-table] to [new-table];
while循环添加测试数据:
declare
i int:=1;
begin
while i<=255 loop
insert into DATAACQUISITIONITEMS_NEW (zhuan_id,Dtid,Dtdy) values(10001001,i,i);
i:=i+1;
end loop;
end;