DELIMITER //
create procedure pro_test()
begin
declare i int;
set i = 0;
while i<5 do
insert into test select i+1,name from crm_contact where id=i+886;
set i=i+1;
end while;
end;
//
DELIMITER ;
DELIMITER //
create procedure pro_test()
begin
declare i int;
set i = 0;
while i<8 do
insert into crm_right select i+824,crm_right.name,
crm_right.rule,
crm_right.action,
crm_right.type,
crm_right.parent_id,
crm_right.scope,
crm_right.code
FROM
crm_right where id = i+80;
set i=i+1;
end whi......
阅读全文