MySQL Stored procedure example

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为错误代码, greater than 0 for the delegate number out  op_msg VARCHAR (30) # return information)    modifies SQL dataproc_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 Stored procedure example