MySQL存储过程实现split代码,MYSQL代码库,德仔网

代码语言

代码分类

【MYSQL】 MySQL存储过程实现split

作者:using / 发布于2012/10/22/ 1203

<div>drop PROCEDURE if exists procedure_split;</div>
<div>CREATE PROCEDURE `procedure_split`(</div>
<div>  inputstring varchar(1000),</div>
<div>  delim char(1)</div>
<div>)</div>
<div>begin</div>
<div>  declare strlen int DEFAULT length(inputstring);</div>
<div>  declare last_index int DEFAULT 0;</div>
<div>  declare cur_index int DEFAULT 1;</div>
<div>  declare cur_char VARCHAR(200);</div>
<div>  declare len int;</div>
<div>  drop temporary table if exists splittable;</div>
<div>  create TEMPORARY table splittable(</div>
<div>    value VARCHAR(20)</div>
<div>  ) ;</div>
<div>  WHILE(cur_index<=strlen) DO  </div>
<div>  begin</div>
<div>    if substring(inputstring from cur_index for 1)=delim or cur_index=strlen then</div>
<div>      set len=cur_index-last_index-1;</div>
<div>      if cur_index=strlen then</div>
<div>       set len=len+1;</div>
<div>      end if;</div>
<div>      insert into splittable(`value`)values(substring(inputstring from (last_index+1) for len));</div>
<div>      set last_index=cur_index;</div>
<div>    end if;</div>
<div>    set cur_index=cur_index+1;</div>
<div>  END;</div>
<div>  end while;</div>
<div>end ;</div>
<div></div>

试试其它关键字

　存储过程实现split　

同语言下

可能有用的

using贡献的其它代码(7)