How can we enable and disable specific MySQL events?

By using the ALTER EVENT statement and the ENABLE and DISABLE keywords, we can enable and disable events. To illustrate this, we have the following example:

Example

mysql> ALTER EVENT hello DISABLE;
Query OK, 0 rows affected (0.00 sec)

The above query will disable the event named 'Hello', the following query will enable it.

mysql> ALTER EVENT hello ENABLE;
Query OK, 0 rows affected (0.00 sec)

The above is the detailed content of How can we enable and disable specific MySQL events?. For more information, please follow other related articles on the PHP Chinese website!