String x "3_SJ454FH";

我想在mysql的一列中存储'3'（在u3;之前），在另一列中存储'sj454fh'（在3;之后）。我尝试过在存储过程中使用substring\ u index函数，但没有成功。那么，有没有办法像这样在存储过程中存储值呢。？

CREATE DEFINER=`root`@`localhost` PROCEDURE `insert_csv`(_list MEDIUMTEXT)
BEGIN
DECLARE _next TEXT DEFAULT NULL;
DECLARE _nextlen INT DEFAULT NULL;
DECLARE _value TEXT DEFAULT NULL;
iterator:
LOOP
  -- exit the loop if the list seems empty or was null;
  -- this extra caution is necessary to avoid an endless loop in the proc.
  IF LENGTH(TRIM(_list)) = 0 OR _list IS NULL THEN
    LEAVE iterator;
  END IF;
  -- capture the next value from the list
  SET _next = SUBSTRING_INDEX(_list,'_',1);
  -- save the length of the captured value; we will need to remove this
  -- many characters + 1 from the beginning of the string 
  -- before the next iteration
  SET _nextlen = LENGTH(_next);
  -- trim the value of leading and trailing spaces, in case of sloppy CSV strings
  SET _value = TRIM(_next);
  -- insert the extracted value into the target table
  INSERT INTO t1 (c1) VALUES (_value);
  -- rewrite the original string using the `INSERT()` string function,
  -- args are original string, start position, how many characters to remove, 
  -- and what to "insert" in their place (in this case, we "insert"
  -- an empty string, which removes _nextlen + 1 characters)
  SET _list = INSERT(_list,1,_nextlen + 1,'');
END LOOP;
END

输出：

id|c1
-----------
1 |3
-----------
2 |SJ454FH
-----------

我试过这个代码，但它存储在下一行。