示例:
a,b,c,d,e,f,g字符串
生成后的表是:
id,value
1,a
2,b
3,c
4,d
5,e
6,f
7,g
a,b,c,d,e,f,g字符串
生成后的表是:
id,value
1,a
2,b
3,c
4,d
5,e
6,f
7,g
解决方案 »
- APMServ5.2.6 mysql提示'root'@'localhost' (using password: YES)
- group by替换产生很多的问题
- mysql make问题
- mysql的A字段设为int类型,可条件为A='adfs'时可得出所有为0的结果,为何?
- 请问支持事务、视图、外键、存储过程的mysql版本在哪儿可以下载到啊?
- 救命啊,linux 下java 访问mysql.……,
- [查询效率*求助*] Mysql 分组查询,获取前2条,10000条记录以上的查询效率问题
- mysql存段落文章的问题
- 这个select能写出来吗?
- c++ mysql ado方式连接问题
- MYSQl多表查询
- mysql与sql server的链接问题
drop procedure if exists buildtable;
delimiter //
create procedure buildtable(in str varchar(128),in sep varchar(10))
begin
declare cnt smallint(4) default 0;
create table if not exists tmptable(id smallint(4) not null default 0,
val varchar(32) not null default ''
)engine = myisam default character set = utf8;
truncate table tmptable;set cnt = length(str) - length(replace(str,sep,'')) + 1;
set @i = 1;
while @i <= cnt do
set @tmp = substring_index(substring_index(str,sep,@i),sep,-1);
insert into tmptable(id,val) values(@i,@tmp);
set @i = @i + 1;
end while;select * from tmptable;
end;
//
delimiter ;call buildtable('yuan.yong.zhi','.');
select @i:=@i+1,mid(a.a1,b.id,1) as newid from (select 'a,b,c,d,e,f,g' as a1) as a
inner join lsb1 b
on length('a,b,c,d,e,f,g')>=b.id where mid(a.a1,b.id,1)<>','lsb1:字段ID,内容为1-10000的数字,根据你的需要
select @i:=@i+1 AS ID,mid(a.a1,b.id,1) as value from (select 'a,b,c,d,e,f,g' as a1) as a
inner join lsb1 b
on length('a,b,c,d,e,f,g')>=b.id where mid(a.a1,b.id,1) <>','