mysql复制事件到另一个库执行

先查询出来库里面的事件并进行拼接。然后到另一个库执行。 

EVENT_SCHEMA：数据库库名

		
		SELECT CONCAT(" CREATE EVENT IF NOT EXISTS  ", 
		EVENT_NAME,
		 " ON SCHEDULE EVERY  ",
		 INterval_value," ", INterval_field," STARTS  '",
		 starts,
		 "' ON COMPLETION  PRESERVE  COMMENT '",
		 event_comment,"'  DO ",
		event_definition ," ; ") 

FROM 
    INFORMATION_SCHEMA.EVENTS 
WHERE 
    EVENT_SCHEMA = 'bidprcu_dbXXXX';