存储过程预处理批量插入数据
CREATE PROCEDURE `proc_name`(in types integer)beginDECLARE ctime int(11);DECLARE goal int(11);set ctime =1;set @sqltext='insert into test(title,direct,clicktime,mtype,goal) values';loop1: WHILE ctime<=15 DOset goal=1;loop2: WHILE goal<=100 DO if ctime=15 and goal=100 then set @sqltext =concat(@sqltext,'(',CONCAT('''diezhongdie',types*1000+ctime*100+goal,''''),',',CONCAT('''haidong',types*1000+ctime*100+goal,''''),',',ctime,',',types,',',goal,')'); else set @sqltext =concat(@sqltext,'(',CONCAT('''diezhongdie',types*1000+ctime*100+goal,''''),',',CONCAT('''haidong',types*1000+ctime*100+goal,''''),',',ctime,',',types,',',goal,'),'); end if;set goal=goal+1;END WHILE loop2;set ctime=ctime+1;END WHILE loop1; prepare stmt from @sqltext; execute stmt; DEALLOCATE PREPARE stmt; set @sqltext='';end;?