mysql查看event内容,如何查看Mysql event事件是否启用

查看mysql事件状态是否开启

mysql> show variables like 'event_scheduler';

+-----------------+-------+

| Variable_name   | Value |

+-----------------+-------+

| event_scheduler | ON    |

+-----------------+-------+

1 row in set (0.00 sec)

或

mysql> select @@event_scheduler;

+-------------------+

| @@event_scheduler |

+-------------------+

| ON                |

+-------------------+

1 row in set (0.00 sec)

*************************************************************

如果没有开启，开启它。

mysql> set global event_scheduler=on;

Query OK, 0 rows affected (0.00 sec)

或

mysql> set global event_scheduler=1;

Query OK, 0 rows affected (0.00 sec)

**************************************************************