首页 > IT职业 > IT生活 > MySQL 存储过程中执行动态SQL语句的方法
?
| 12345678910 |
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;
|
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2231/viewspace-2804870/ ,如需转载,请注明出处,否则将追究法律责任。