MySQL 存储过程示例

BEGIN
	DECLARE  no_more_record INT DEFAULT 0;
	DECLARE work_num INT DEFAULT 0;
	DECLARE work_id BIGINT(20);
	
	DECLARE work_cursor CURSOR
	FOR 
		SELECT id FROM zw_project_school_unit;

	DECLARE  CONTINUE HANDLER FOR NOT FOUND  SET  no_more_record = 1;

	OPEN work_cursor;
	
	FETCH work_cursor INTO work_id;

	WHILE no_more_record != 1 DO
		SET work_num = work_num + 1;
		UPDATE zw_project_school_unit SET work_code = work_num WHERE id = work_id;
		FETCH  work_cursor INTO work_id;
	END WHILE;
	
	CLOSE  work_cursor;
END