mysql5.6下载和安装,直接解压缩运行,你知道myql5.6如何下载和安装吗?并且不需要繁琐的安装过程,直接解压缩就可以运行,下面将详细介绍......
mysql怎么建立事件
我和大家分享一下在mysql怎么建立事件。我写的经验对你学习mysql有帮助的话,给我投票、点赞或者收藏!
工具/原料
- mysql5.6
方法/步骤
登录mysql,在test数据库中新建一个表:
CREATETABLE`chengshi`(`id`int(11)NOTNULLAUTO_INCREMENT,`shengfen`varchar(10)NOTNULL,`chengshi`varchar(10)NOTNULL,`shijian`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMP,`zhujima`varchar(10)NOTNULLDEFAULT'binary',PRIMARYKEY(`id`),UNIQUEKEY`chengshi`(`chengshi`))ENGINE=InnoDBAUTO_INCREMENT=10DEFAULTCHARSET=utf8
在表中增加一些数据:
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('1','河南','安阳','2019-03-14 09:57:29','ay');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('2','河南','郑州','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('3','河南','洛阳','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('4','河南','漯河','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('5','河南','新乡','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('6','河南','濮阳','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('7','河南','焦作','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('8','河南','鹤壁','2019-03-05 10:14:27','');
insert into `chengshi` (`id`, `shengfen`, `chengshi`, `shijian`, `zhujima`) values('9','河南','开封','2019-03-05 10:14:27','');
在test数据库中新建一个事件,每天执行一次:
DELIMITER $$
CREATEEVENT `test`.`abc`
ON SCHEDULE EVERY 1 SECOND STARTS '2019-02-12 18:00:00' ON COMPLETION PRESERVE ENABLE
DO
BEGIN
(sql_statements)
$$
DELIMITER ;
在事件过程中把chengshi表的数据导出:
SET @bfsql=CONCAT('select * from chengshi into outfile ','''c:\chengshi',DATE_FORMAT(NOW(),'%Y%m%d%H%i%S'),'.xls''',' CHARACTER SET gbk');
PREPARE bf_data FROM @bfsql;
EXECUTE bf_data;
DEALLOCATE PREPARE bf_data;
执行命令,新建事件。
怎么开始运行事件呢:
SET GLOBAL event_scheduler=1;
以上方法由办公区教程网编辑摘抄自百度经验可供大家参考!
相关文章