· 9 years ago · Feb 02, 2017, 02:34 AM
1show processlist;
2SET GLOBAL event_scheduler = ON;
3show processlist;
4
5------------------------------------------------------------------------------------------------
6
7CREATE TABLE IF NOT EXISTS `temparchive` (
8 `UpdateDate` datetime NOT NULL,
9 `Description` varchar(50) NOT NULL
10) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11
12-------------------------------------------------------------------------------------------------
13
14
15Delimiter $$
16CREATE EVENT myevent
17ON SCHEDULE EVERY '0:30' MINUTE_SECOND
18DO BEGIN
19 Update temparchive Set UpdateDate = upper(now());
20END $$