delimiter //
drop procedure if exists looppc;
create procedure looppc()
begin
declare i int;
declare m1 varchar(1000);
SET @m1 = "SELECT * FROM `zjxx_exampeople` WHERE 1=1 ";
prepare stmt from @m1;
EXECUTE stmt;
deallocate prepare stmt;
END; //
CALL looppc()
存储过程执行拼接的sql
最新推荐文章于 2024-06-03 17:02:39 发布