1
、建立测试表:
create table test_table1(t1 integer,t2 integer);
insert into test_table1 values(1,2);
insert into test_table1 values(2,2);
create table test_table(t1 integer,t2 integer)
2
、建立存储过程:
CREATE PROCEDURE soa_tet()
DEFINE v_t1 integer;
DEFINE v_t2 integer;
FOREACH
SELECT first 2 t1,t2
INTO v_t1,v_t2
FROM test_table1
where 1=1 order by t1
insert into test_table(t1,t2) values(v_t1,v_t2)
;
END FOREACH;
END PROCEDURE;
3
、测试
execute procedure soa_tet();
select * from test_table