MySQL存储过程中执行动态SQL语句的方法_MySQL
来源：动视网
责编：小采
时间：2020-11-09 19:37:29
MySQL存储过程中执行动态SQL语句的方法_MySQL
MySQL存储过程中执行动态SQL语句的方法_MySQL: 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;
导读MySQL存储过程中执行动态SQL语句的方法_MySQL: 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;
MySQL存储过程中执行动态SQL语句的方法_MySQL
MySQL存储过程中执行动态SQL语句的方法_MySQL: 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;
