Mysql查看事件、存储函数的状态与启动

    xiaoxiao2022-06-26  92

    查看是否开启:

    mysql> show variables like 'event_scheduler'; +-----------------+-------+ | Variable_name   | Value | +-----------------+-------+ | event_scheduler | OFF   | +-----------------+-------+ 1 row in set (0.00 sec) ---------------------

     

     开启方法:

    # 方法1: mysql> set global event_scheduler=on; Query OK, 0 rows affected (0.00 sec) # 方法2: mysql> set global event_scheduler=1; Query OK, 0 rows affected (0.00 sec)

     


    最新回复(0)