如题,我想将存储过程交给后处理,创建出存储过程后调用
如以下存储sql:
DROP PROCEDURE IF EXISTS PROCEDURE_test3
;
CREATE PROCEDURE PROCEDURE_test3()
BEGIN
DECLARE var1 VARCHAR(1000);
set var1 ='SELECT * from t_transmission_equipment where 1=1';
set @v_sql=var1;
prepare stmt from @v_sql;
EXECUTE stmt;
deallocate prepare stmt;
END;
什么意思?
我用过mybatis调用存储过程
创建存储过程,调用很简单的