mysql 存储过程

 

DELIMITER $$

CREATE PROCEDURE build_school_list ()
BEGIN

 DECLARE v_finished INTEGER DEFAULT 0;
        DECLARE v_shcool varchar(100) DEFAULT "";
				DECLARE v_shengfen varchar(100) DEFAULT "";
				DECLARE v_shi varchar(100) DEFAULT "";

 -- declare cursor for employee email
 DEClARE school_cursor CURSOR FOR 
      SELECT 校区,省份,市 FROM school;

 -- declare NOT FOUND handler
 DECLARE CONTINUE HANDLER 
      FOR NOT FOUND SET v_finished = 1;

 OPEN school_cursor;

 get_school: LOOP

 FETCH school_cursor INTO v_shcool,v_shengfen,v_shi;

 IF v_finished = 1 THEN 
 LEAVE get_school;
 END IF;

  update ec_data set 省份 = v_shengfen, 市 = v_shi where 所在校区 = v_shcool;
 -- build email list
 -- SET email_list = CONCAT(v_email,";",email_list);

 END LOOP get_school;

 CLOSE school_cursor;

END$$