MySQL 存储过程中执行动态SQL语句的方法_MySQL
程序员文章站
2022-04-19 18:09:19
...
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】MySQL的存储引擎