Mysql 存储过程

[b]1. 创建一个存储过程[/b]

CREATE  PROCEDURE T6125_Init()

[b]2. 删除一个存储过程[/b]

DROP PROCEDURE IF EXISTS  T6125_Init;

[b]3.最基本的格式[/b]

 BEGIN
 END;

[b]4. 声明的语句[/b]

   DECLARE 	_error INT DEFAULT 0;
   DECLARE _F01 INT DEFAULT 0;

[b]5. 游标[/b]

  DECLARE _t6125 CURSOR FOR SELECT xxx;
  OPEN _t6125;
  REPEAT 
	FETCH _t6125 INTO _F01;
  IF NOT _done THEN
	START TRANSACTION;
  	IF _error = 1 THEN
						ROLLBACK;
						SET _error = 0;
				ELSE
						COMMIT;
				END IF;
		END IF;
	UNTIL _done END REPEAT;
	CLOSE _t6125;

[b]6. 出错控制[/b]

  DECLARE 	CONTINUE 		HANDLER FOR SQLEXCEPTION  SET _error = 1;

[b]7. 游标结束控制[/b]

  DECLARE 	CONTINUE 		HANDLER FOR NOT FOUND SET _done = 1;