mysql 事件
作者:admin 日期:2013-08-15 15:11:44
/* begin of added by zhugexh for event_create_table_attachment 2013-07-11 */
DELIMITER $$
SET GLOBAL event_scheduler = ON$$
Drop EVENT IF EXISTS `event_create_table_attachment`$$
Create EVENT `event_create_table_attachment`
ON SCHEDULE
EVERY 1 YEAR
STARTS '2013-12-25 03:52:59'
ON COMPLETION PRESERVE ENABLE
DO
BEGIN
call prc_create_table_nextyear_attachment();
END$$
DELIMITER ;
/* end of added by zhugexh for event_create_table_attachment 2013-07-11 */
DELIMITER $$
SET GLOBAL event_scheduler = ON$$
Drop EVENT IF EXISTS `event_create_table_attachment`$$
Create EVENT `event_create_table_attachment`
ON SCHEDULE
EVERY 1 YEAR
STARTS '2013-12-25 03:52:59'
ON COMPLETION PRESERVE ENABLE
DO
BEGIN
call prc_create_table_nextyear_attachment();
END$$
DELIMITER ;
/* end of added by zhugexh for event_create_table_attachment 2013-07-11 */