你是运行否对获得一个MySQL事件的实际操作感到十分头疼?如果是这样子的话,以下的介绍文章将会给你相应的解决方案,以下的正确文章主要是介绍获得一个MySQL事件的方案,以下就是运行相关内容的具体描述。
操作系统中的介绍计划任务(WINDOWS)或CRONTABL(LINUX/UNIX)
MySQL版本5.1以上,create event
- CREATE
- [DEFINER = { user | CURRENT_USER }]
- EVENT
- [IF NOT EXISTS]
- event_name
- ON SCHEDULE schedule
- [ON COMPLETION [NOT] PRESERVE]
- [ENABLE | DISABLE | DISABLE ON SLAVE]
- [COMMENT 'comment']
- DO sql_statement;
- schedule:
- AT timestamp [+ INTERVAL interval] ...
- | EVERY interval
- [STARTS timestamp [+ INTERVAL interval] ...]
- [ENDS timestamp [+ INTERVAL interval] ...]
- interval:
- quantity { YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
- WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
- DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}
- MySQL> SELECT NOW();
- +---------------------+
- | NOW() |
- +---------------------+
- | 2006-02-10 23:59:01 |
- +---------------------+
- 1 row in set (0.04 sec)
- MySQL> CREATE EVENT e_totals
- -> ON SCHEDULE AT '2006-02-10 23:59:00'
- -> DO INSERT INTO test.totals VALUES (NOW());
- Query OK,正确 0 rows affected, 1 warning (0.00 sec)
- MySQL> SHOW WARNINGS\G
(责任编辑:热点)
兴胜创建(00896.HK)因行使购股权配发1090.9万股 每股发行价1.16港元
女演员Bunny Marthy参与CDPR动捕 疑似巫师新作
金通灵(300091.SZ):南通科创未减持公司股份 减持计划期限届满