Unanswered: Trigger creation inside a stored procedure
I am new to mysql. I have a requirement as need to drop all the triggers on few tables & after some operations, again need to recreate them. I can easily do this on sql server & db2 as we have options called disable trigger & dynamic trigger creation inside a stored procedure, which is not available in mysql at all.
As I am new bee can't able to think beyond my knowledge on mysql.
can some one kindly provide me a outer view to accomplish this.
I just want to create a trigger inside a stored procedure .