Re: Calling stored procedures ... Dynamic SQL

[Roland Bouman]

Hi,


create procedure p()
begin
-- build the string anyway you like
set @stmt := 'create table t(id int)';
prepare stmt from @stmt;
execute stmt;
-- dont forget to deallocate, you'll get ito trouble.
deallocate prepare stmt;
end;


see also:

http://forge.mysql.com/snippets/view.php?id=13

good luck!