MySQL 存储过程中执行动态SQL语句的方法

drop procedure if exists my_procedure; 
create procedure my_procedure() 
begin 
  declare my_sqll varchar(500); 
  set my_sqll='select * from aa_list'; 
 set @ms=my_sqll; 
 prepare s1 from @ms; 
 execute s1; 
 deallocate prepare s1; 
end;