MySql游标使用

beginDECLARE tmp varchar(128); DECLARE no int;DECLARE primaryKEy int;DECLARE cur CURSOR FOR SELECT name FROM t_article_para_item; DECLARE CONTINUE HANDLER FOR NOT FOUND SET no=1; #当读到数据的最后一条时,设置no变量为1SET no=0; #初始化变量no为0set primaryKEy = 124;OPEN cur; #打开游标while no=0 do #判断是不是到了最后一条数据fetch cur into tmp; #读取游标中的数据一一复给变量o。set primaryKEy=primaryKEy+1;insert into core_ctype_config_backup values (inx,0,tmp,1031,1,null,1,1,NOW(),null,null);#这个不用解释了吧end while;close cur;#最后关闭游标.游标里面存放了那么多数据总是要清理掉的吧。end