零捱科技网

全部频道

您的当前位置：首页MySQL存储过程中执行动态SQL语句的方法

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;

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;
显示全文