Re: Simple stored procedure question

[Peter Brawley]

Hi Les,

Nice try :-). MySQL insists that we prepare from a user variable, so it will give you a syntax error if you try to prepare directly from a concat() call.

User vars (unlike LOCAL vars) are auto-declared when you SET them, likewise stmts when you prepare them eg...

delimiter |
create procedure tst()
begin
set @s = 'select * from foo';
prepare s from @s;
execute s;
deallocate prepare s;
end;
|
delimiter |

PB