存储过程中用预处理
delimiter $$
drop procedure if exists procPrepare$$
create procedure procPrepare(in field1 int,in field2 int,in field3 int)
begin
prepare stmt from "insert into tbl_temp(field_a,field_b,field_c) values(?,?,?) ";
execute stmt using field1,field2,field3;
end$$
delimiter ;
这样有什么错误?为什么编译不了.
[解决办法]
using 后面必须是静态的值，不能是动态变量。
delimiter $$
drop procedure if exists procPrepare$$
create procedure procPrepare(in field1 int,in field2 int,in field3 int)
begin
set @str = concat( 'insert into tbl_temp(field_a,field_b,field_c) values( ',field1, ', ',field2, ', ',field3, ') ');
prepare stmt from @str;
execute stmt;
deallocate prepare stmt;
end$$
delimiter ;
(0 row(s)affected)
(0 ms taken)
(0 row(s)affected)
(0 ms taken)
