帮助编写一个简单mysql存储过程

[kgxiang]

创建一个带参数存储过程myp ( par1 varchar(100))
begin

end;

参数par1 为用逗号分隔的字符串 例如: name1,name2,name3

现需要把par1中逗号前的字符串,都插入表user 中
sql :
insert user() value('name1');
insert user() value('name2');
insert user() value('name3');

请问在存储过程中如何去解析字符,进行叠代插入表?

[懒得去死]

This is a simple answer,you can make your own mind to finishe it.

set @str = '1,2,3,4';
select substring_index(@str,',',1);  -- Get the first one.
select reverse(substring_index(reverse(substring_index(@str,',',2)),',',1));  -- Get the second one.
...