Mysql编写存储过程01

-- 存储过程创建
DROP PROCEDURE IF EXISTS PRO_RATE_SHIPMENT;
DELIMITER $$
CREATE PROCEDURE PRO_RATE_SHIPMENT(IN r_param1 VARCHAR(2000) )
	BEGIN	
			DECLARE in_param1 VARCHAR(20);
			DECLARE in_param2 VARCHAR(2000);
			DECLARE in_param3 VARCHAR(2000);
			-- 对输入参数进行处理
			SET in_param1 = SUBSTR(r_param1,1,19);
			SET in_param2 = REPLACE(r_param1,'-',',');
			SET in_param3= SUBSTR(in_param2,26);
			
-- 			-- 测试输出语句
			SELECT in_param1,in_param2,in_param3;
	END$$
	
DELIMITER ;

-- 执行存储过程
CALL PRO_RATE_SHIPMENT('1705978375876026371=====-1705978376480006147-1705978376610029570-1705978376735858690');