mysql 存储过程数组分割

in `_str`varchar(8000),out `outstr`varchar(8000)

BEGIN

if instr(_str,',')>0 THEN
select CONCAT("'",REPLACE(_str,',',"','"),"'") into outstr;
else
select _str into outstr;
END IF;
END

posted @ 2019-04-26 15:09  嗯哼,还好  阅读(1094)  评论(0编辑  收藏  举报