1、登录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
2、在表中增加一些数据：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','');
3、在test数据库中新建一个事件，每天执行一次:DELIMITER $$CREATE EVENT `test`.`abc`ON SCHEDULE EVERY 1 SECOND STARTS '2019-02-12 18:00:00' ON COMPLETION PRESERVE ENABLEDO BEGIN (sql_statements) END$$DELIMITER ;
4、在事件过程中把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;
5、执行命令，新建事件。
6、怎么开始运行事件呢：SET GLOBAL event_scheduler=1;
