Passing parameter to a Trigger

Can I pass parameters to a Trigger?
LVL 8
rpkhareAsked:
Who is Participating?
 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
Khare-

Personally I feel like trigger itself is a overhead.. and calling a SP inside is adding some more sugar...
Coming to advantage... just take your example you wanted to pass parameter to trigger but trigger can't be directly called..so what you do is..call a sp inside a trigger and use the parameter..

Thanks,
Umesh
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
"no", as you do not call a trigger. a trigger has only the data available for which rows have been updated/deleted/inserted, and all the data in the tables.

what are you trying to achieve?
0
 
rpkhareAuthor Commented:
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.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
UmeshMySQL Principle Technical Support EngineerCommented:
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?

0
 
rpkhareAuthor Commented:
Will it be an overhead or not? What is the advantage of calling a Stored Procedure from a trigger?
0
 
rpkhareAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.