实现mysql 的分割字符功能 drop procedure if exists db_test.proc_test;create procedure proc_test()begindeclare b varchar(500);declare sqls varchar(1000); set b='123;234;567;789'; drop table if exists splittable;create temporary table splittab
实现mysql 的分割字符功能
drop procedure if exists db_test.proc_test;create procedure proc_test()begin declare b varchar(500); declare sqls varchar(1000); set b='123;234;567;789'; drop table if exists splittable; create temporary table splittable( id int auto_increment primary key, value varchar(20) ); set sqls=concat(insert into splittable(value) values (',replace(b,';','),('),')); select sqls; set @sql=sqls; #必须这样转一样 prepare stem from @sql; execute stem; deallocate prepare stem; select * from splittable;end;
?
?