那不是触发器的开关,是事件的开关。 MySQL 5.1.6 之后,你可以直接使用类似于oralce job的mysql event首先,检查一下你的MYSQL是否打开了这项功能。SQL codemysql> show variables like '%sc%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | event_scheduler | OFF | +-----------------+-------+ 1 row in set (0.00 sec) 默认下是未打开的,你可以到 my.ini (windows)/ my.cnf (linux/unix) 参数文件中定义后重启mysqld 或者直接 set global event_scheduler=on;SQL codemysql> show variables like '%sc%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | event_scheduler | ON | +-----------------+-------+ 1 row in set (0.00 sec)
MySQL 5.1.6 之后,你可以直接使用类似于oralce job的mysql event首先,检查一下你的MYSQL是否打开了这项功能。SQL codemysql> show variables like '%sc%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | OFF |
+-----------------+-------+
1 row in set (0.00 sec)
默认下是未打开的,你可以到 my.ini (windows)/ my.cnf (linux/unix) 参数文件中定义后重启mysqld
或者直接 set global event_scheduler=on;SQL codemysql> show variables like '%sc%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)