mysql存储过程分割字符串

DROP PROCEDURE IF EXISTS split_string;CREATE PROCEDURE split_string(IN to_split VARCHAR(255), IN split_with VARCHAR(100))BEGIN  DECLARE total_length INT;  DECLARE location INT;  DROP TEMPORARY TABLE IF EXISTS temp_store;  CREATE TEMPORARY TABLE temp_store(str VARCHAR(100));  WHILE LENGTH(to_split) > 0  DO    SET total_length = LENGTH(to_split);    SET location     = LOCATE(split_with, to_split);    IF location = 0 THEN      INSERT INTO temp_store(str) VALUE(to_split);      SET to_split = '';    ELSE         INSERT INTO temp_store(str) VALUE(LEFT(to_split, location-1));      SET to_split = RIGHT(to_split, total_length-location);    END IF;    END WHILE;  SELECT * FROM temp_store;end