Re: Table-valued parameters to a stored procedure

[Peter Brawley]

Scott, is this what you mean?

drop procedure if exists str2table;
delimiter go
create procedure str2table( ptxt text )
begin
  drop temporary table if exists t;
  create temporary table t( txt text );
  insert into t values( ptxt );
  drop temporary table if exists temp;
  create temporary table temp( val char(255) );
  set @sql = concat( "insert into temp (val) values ('", 
                     replace(( select group_concat(distinct txt) as data from t), 
                     ",", "'),('"),"');"
                   );
  prepare stmt1 from @sql;
  execute stmt1;
 end;
go
delimiter ;
call str2table( '1,2,3,4,5,6,7,8,9' );
select * from temp;

Edited 1 time(s). Last edit at 12/10/2021 08:26PM by Peter Brawley.