you should read the following post: http://www.sitepoint.com/how-to-create-mysql-events/ -- Regards, Kalyankumar Ramaseshan On Sat, Mar 8, 2014 at 10:59 PM, Savita Agrawal <savitarit0@gmail.com> wrote:
Hi,
what is the difference between a trigger and user defined event?
In postgres there is a clear distintion between trigger and event trigger. Triggers are activated when DML statements are executed whereas event triggers are activated when DDL statements are executed.
But in soliddb (from which our post in JIRA page is inspired), it seems like user defined events can be activated for DML statements. What is it that can't be done with triggers and can be done with user defined event?
Why is the restriction that events can only be posted and received by stored procedures only?
Cheers, Savita
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp