急！怎样将这个MS SERVER功能转化成MY SQL

[chenguniversity]

declare @sql varchar(8000)
set @sql=''
declare @index int
set @index=1
while @index<11
begin
set @sql='select type_value'+@index'+ from tempTable where type_type'+@index+' in(4,5,6)'
execute(@sql)
set @index=@index+1
end

[guguda2008]

帮顶MYSQL

[liangCK]

delimiter $$
drop procedure if exists p_Dynamic$$;

create procedure p_Dynamic()
begin
    declare i int default 1;
    while i < 11 do
         set @stmt = concat('select type_value',i,
                              ' from tempTable where type_type',i,' in(4,5,6)');
         prepare stmt from @stmt;
         execute stmt;
         dealocate prepare stmt;

         set i = i+1;
    end while;
end$$
delimiter ;

[liangCK]

大概是这样子.没测试过.