mysql怎么存数组

DECLARE arrLength INT DEFAULT 0;/*定义数组长度*/

DECLARE arrString VARCHAR(1000);/*定义初始数组字符*/

DECLARE sStr VARCHAR(1000);/*定义初始字符*/

SET arrLength = LENGTH(arrayStr) - LENGTH(REPLACE(arrayStr,sSplit,''));/*获得数组长度*/

SET arrString = arrayStr;/*赋值*/

DROP TEMPORARY TABLE IF EXISTS list_tmp;

create temporary table list_tmp(id VARCHAR(32));/*定义临时表*/

WHILE arrLength > 0 DO

  set sStr = substr(arrString,1,instr(arrString,sSplit)-1);            -- 得到分隔符前面的字符串 

  set arrString = substr(arrString,length(sStr)+length(sSplit)+1);     -- 得到分隔符后面的字符串 

  set arrLength = arrLength -1;

  set @str = trim(sStr);

  insert into list_tmp(id) values(@str);

END WHILE;