Can we execute a dynamic sql in a stored procedure,like sqlserver?

[xiang zou]

hi all:
i have some problems during developing with mysql
problems below:

Can we execute a dynamic sql in a procedure,like sqlserver?

for example:
in sqlserver,we can make it like this:

declare @sql varchar(4000)
set @sql = "select * from sampleTable where id in '("+@idcollections+")'"
exec (@sql)
........

i use mysql 5.0.12 beta,help me,thanks



Edited 3 time(s). Last edit at 09/17/2005 04:02AM by xiang zou.