mysql怎么建立事件

我和大師分享一下在mysql怎么成立事務。我寫的經驗對你進修mysql有幫忙的話，給我投票、點贊或者保藏！

東西/原料

mysql5.6

方式/步調

1
登錄mysql，在test數據庫中新建一個表：
CREATE TABLE `chengshi` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shengfen` varchar(10) NOT NULL, `chengshi` varchar(10) NOT NULL, `shijian` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `zhujima` varchar(10) NOT NULL DEFAULT 'binary', PRIMARY KEY (`id`), UNIQUE KEY `chengshi` (`chengshi`)) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=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 ENABLE
DO
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;

發表于 2019-03-14 20:01
閱讀 ( 963 )
分類：其他類型

mysql怎么建立事件

東西/原料

方式/步調

你可能感興趣的文章

相關問題

0 條評論

作家榜 ?

推薦文章