摘要:
DELIMITER $$DROP PROCEDURE IF EXISTS `SPLIT_SUB_STR0`$$CREATE DEFINER=`admin`@`%` PROCEDURE `SPLIT_SUB_STR0`(INOUT str VARCHAR(1000) , split0 VARCHAR(1) ,OUT split VARCHAR(20))BEGINDECLARE c INT;SET c=0;SET c = LENGTH(SUBSTRING_INDEX(str,split0,1));SET split = SUBSTRING(str, 1, c);SET str = SUBSTRIN 阅读全文