动态执行Sql

动态执行sql语句，把存储过程灵活的运用起来

delimiter  $$
drop procedure if exists proc $$
create procedure proc(in StrSql varchar(128) , in nid int )
begin
    set @id = nid;
    set @ssql = StrSql;
    create prod from @ssql;
    execute prod using @id;
    deallocate prepare prod;
end $$
delimiter ;