MySQL Forums
Forum List  »  Events (Job Scheduler)

Re: trying to use an event
Posted by: Dimitris Papageorgiou
Date: September 02, 2016 08:21AM

here http://dev.mysql.com/doc/refman/5.7/en/create-event.html towards the end there is an example of an event that calls a procedure,based on it I have the following question.In the example the parameters given to the procedure are 5 and 27.

My problem is that these parameters must be different every time the procedure is called(as set by the event).

How can this be achieved?since once the event is written the parameters are fixed.
In my case though they must be different every time.

Options: ReplyQuote


Subject
Views
Written By
Posted
933
September 01, 2016 07:25AM
445
September 01, 2016 11:06AM
436
September 01, 2016 09:55PM
432
September 01, 2016 11:22PM
Re: trying to use an event
464
September 02, 2016 08:21AM
576
September 02, 2016 11:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.