mysql 定时任务

2015-06-24 00:14:35 catherine

一、查看event是否开启 show variables like '%sche%'; 开启event_scheduler set global event_scheduler =1; 二、创建存储过程test CREATE PROCEDURE test () BEGIN update test.`userinfo` SET endtime = now() WHERE id = '155'; /*更新test数据库的userinfo表*/ END; 三、创建event e_test create event if not exists e_test on schedule every 30 second on completion preserve do call test(); 每隔30秒将执行存储过程test 关闭事件任务 alter event e_test ON COMPLETION PRESERVE DISABLE; 开户事件任务 alter event e_test ON COMPLETION PRESERVE ENABLE;

分类: web

标签:

微信号：腾讯云折扣返现

技术讨论QQ群： 863102326

作者: catherine

搜索

study ab amap apache apahe awk aws bat centos CFS chrome cmd cnpm composer consul crontab css curl cygwin devops di docker docker,docker-compose ethereum excel fiddler fluentd framework front-end git gitgui github glide go golang gorm grafana gzip ioc item2 iterm2 javascript jenkins jsonp kafka laradock laravel larval linux liunux log mac mac, wi-fi macos magento mariaDB minikube mongoDB msp mysql netbeans nginx nodejs nohup npm nsq php php-fpm php7 phpstorm php扩展 Protobuf python redis scp server shell soap socket socket5 sql sre ssdb ssh ssl study sublime swift system td-agent uml v2ray vagrant vagrnat vim vpn vue vue.js webpack webrtc websocket webtatic windows windows7 word wps xdebug yarn yii2 yum zookeeper 世界国家互联网以太坊分类前端小程序打印机排序算法搞笑权限粤语缓存网络虚拟机视频设计模式项目管理