dropPROCEDUREifexistsmy_procedure;createPROCEDUREmy_procedure()BEGINdeclaremy_sqllvarchar(500);setmy_sqll='select*fromaa
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;