Re: Table-valued parameters to a stored procedure

[Scott Klein]

Thanks Jon,

I've read about the group_contat function...I'm having trouble getting it to work with a variable instead of selecting from a table. Is this possible, using @data instead of "select from data" as in the example below?

set @data = '1,2,3,4,5,6,7,8,9';

CREATE TEMPORARY TABLE items(item text );

set @sql = concat("insert into items (item) values ('", replace(( select
group_concat(distinct txt) as data from t), ",", "'),('"),"');");

prepare stmt1 from @sql;
execute stmt1;
select item from items;