[Quote]哦 弄错了,是使用下面这个看状态,而不是mysql> SHOW EVENTS\G 对不对?
mysql> SHOW VARIABLES LIKE 'event_scheduler';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)[/Quote]是的,是用SHOW VARIABLES来看变量。
哦 弄错了,是使用下面这个看状态,而不是mysql> SHOW EVENTS\G 对不对?
mysql> SHOW VARIABLES LIKE 'event_scheduler';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)