存储过程：
create procedure myproc()
begin
declare num int;declare charName char(10);declare charEmail char(20);set num=3;while num < 20 doset charName=CONCAT(‘a3545’,num);set charEmail=CONCAT(‘a3545′,num,’@qq.com’);insert into pre_common_member values(num,charName,charEmail,’5f591898edd5d9c4e377a45c2f7f5574′,0,0,0,0,1,1,0,”,1417239460,2,0,”,0,0,0,1,0,0,0);insert into pre_ucenter_members value(num,charName,’5f591898edd5d9c4e377a45c2f7f5574′,charEmail,”,”,’hidden’,1417239444,0,0,’447c25′,”);insert into pre_ucenter_memberfields VALUES(num,”);insert into pre_common_member_status value(num,”,’::1′,50620,1417241419,1417239531,0,0,0,0,0,0,0,0);insert into pre_common_member_profile value(num,”,0,0,0,0,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”,”);insert into pre_common_member_field_forum values(num,0,26,”,”,”,”,”,”,”);insert into pre_common_member_field_home values(num,”,”,”,”,0,0,0,”,”,”,”,”,”,”,”,”,”);insert into pre_common_member_count values(num,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);set num=num+1;end while;COMMIT;
end
调用存储过程：call myproc();
，人生至少要有两次冲动，一为奋不顾身的爱情，一为说走就走的旅行。
