实现mysql的瓜分字符功能

实现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;7'; DROP table IF EXISTS splittable;CREATE TEMPORARY TABLE splittab

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;7'; 
	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;

?

?