MySQL procedure

DELIMITER  $$
DROP PROCEDURE IF EXISTS `test`.`myinsert` $$

create procedure `test`.`myinsert`()
begin
 declare id int;
 declare size long;
 declare en longtext;
 declare es longtext;
 set id = 1;
 select count(*) into size from en_es;
 while id  <= size do
  IF (id%2)=1 then
   select en_es.seg into en from en_es where en_es.id = id;
  else
   select en_es.seg into es from en_es where en_es.id = id;
  end if;
  IF (id%2)=0 then
   ##select en,es;
   insert into result values(null, en, es);
   set en=NULL,es=NULL;
  end if;
  set id = id + 1;
 end while;
end$$

DELIMITER ;

call myinsert();