<div>
Actually I want to update an old record in a table in which a new record is inserted. From your answer it seems that I'll have to write a Stored Procedure.
</div>


Actually I want to update an old record in a table in which a new record is inserted. From your answer it seems that I'll have to write a Stored Procedure.

<div>
I'm agree with Angelll on can't pass parameter directlyto triggers bcoz you do not call a trigger.<br />
<br />
But how about calling a stored procedure inside a trigger and availing the required parameter???<br />
<br />
Inside trigger you call a sp like this..<br />
<br />
call uNeedParameter(OUT param1); <br />
<br />
or<br />
<br />
call uNeedParameter(@param1);<br />
<br />
Later you can use ' param1' in the body of trigger? <br />
<br />
Does it make sense? <br />
<br />

</div>


I'm agree with Angelll on can't pass parameter directlyto triggers bcoz you do not call a trigger.

But how about calling a stored procedure inside a trigger and availing the required parameter???

Inside trigger you call a sp like this..

call uNeedParameter(OUT param1);

or

call uNeedParameter(@param1);

Later you can use ' param1' in the body of trigger?

Does it make sense?



<div>
Will it be an overhead or not? What is the advantage of calling a Stored Procedure from a trigger?
</div>


Will it be an overhead or not? What is the advantage of calling a Stored Procedure from a trigger?

<div>
<div class="content wysiwyg-content">
Can I pass parameters to a Trigger?
</div>
</div>


Passing parameter to a Trigger

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.