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

数据库  /  管理员 发布于 7年前   397

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;