Re: INSERT INTO EXEC

[Roland Bouman]

This is not supported in mysql.

If your procedures contain only a single select statement, you could try to do it like this:

select concat(
'INSERT INTO '
,<some expression for you table>
,' (col1,col2,...)'
,routine_definition
)
into @mystmt
from information_schema.routines
where <some intelligent where expression>
;

prepare mystmt from @mystmt;
execute mystmt;
deallocate prepare mystmt;

This would at least save you the work of rebuilding the procedures.