如题,我想将存储过程交给后处理,创建出存储过程后调用
如以下存储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;