56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE DELIM
(IN P_STR CHAR(20),
OUT P_L INT,
OUT P_M INT,
OUT P_N INT)
BEGIN
DECLARE L INT DEFAULT 0;
DECLARE M INT DEFAULT 0;
DECLARE N INT DEFAULT 0;
DECLARE STR CHAR(20);
SET STR = P_STR;
SELECT SUBSTRING_INDEX(STR,'(',1) INTO L;
SET P_L = L;
SELECT SUBSTRING_INDEX((SUBSTRING_INDEX(STR,'(',-1)),',',1) INTO M;
SET P_M = M;
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(STR,',',-1),')',1) INTO N;
SET P_N = N;
END