mysql的存储过程举例_MySQl存储过程例子

DELIMITER $$

USE `weipansettlementdb`$$

DROP PROCEDURE IF EXISTS `proc_demo`$$

CREATE DEFINER=`weipan_jy`@`localhost` PROCEDURE `proc_demo`(

p_demo VARCHAR(8),#参数

OUT op_code INT,#小于0为错误代码, 大于0为委托单号

OUT op_msg VARCHAR(30)#返回信息

)

MODIFIES SQL DATA

proc_demo:

BEGIN

DECLARE v_demo VARCHAR(8);

DECLARE EXIT HANDLER FOR SQLEXCEPTION

BEGIN

SHOW WARNINGS;

ROLLBACK;

SET op_code=-1;

SET op_msg=`flot_getmsg`(-1);

END;

SET op_code=-1;

SELECT `demo` INTO v_demo

FROM `t_demo` WHERE `demo` = p_demo;

IF v_demo = p_demo THEN

LEAVE proc_demo;

END IF;

START TRANSACTION;

COMMIT;

SET op_code = 0;

SET op_msg=`flot_getmsg`(0);

END$$

DELIMITER ;

MySQl存储过程例子

标签：csharp   tran   handle   委托   pre   arch   例子   参数   creat

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/CarlBlogs/p/7405518.html