MySQL Forums
Forum List  »  MySQL Workbench

EVENT names based on query
Posted by: Martin Groenescheij
Date: March 20, 2014 05:18AM

How can I create a new EVENT with a dynamic name based on a query?
My intention is to send out notifications based on a date and time.
Each time a record is added to a table it should trigger to create an event which is scheduled once.
This means that an event need to be create for each record in the table and therefor requires a uniqe name e.g. notify-0001 for the first record.

Thanks for your help

Options: ReplyQuote


Subject
Views
Written By
Posted
EVENT names based on query
1332
March 20, 2014 05:18AM
495
March 21, 2014 02:21AM


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.