I'm happy to live!

  查看event是否開啟

  show variables like '%sche%';

  將事件計劃開戶

  set global event_scheduler =1;

  創(chuàng)建存儲過程test

  CREATE PROCEDURE test ()
  BEGIN
  update examinfo SET endtime = now() WHERE id = 14;
  END;

  創(chuàng)建event e_test

  create event if not exists e_test
  on schedule every 30 second
  on completion preserve
  do call test();

  每隔30秒將執(zhí)行存儲過程test,將當前時間更新到examinfo表中id=14的記錄的endtime字段中去.

  關閉事件任務

  alter event e_test ON
  COMPLETION PRESERVE DISABLE;

  開戶事件任務
  alter event e_test ON
  COMPLETION PRESERVE ENABLE;

  以上測試均成功,測試環(huán)境為mysql 5.4.2-beta-community mysql community server(GPL)