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,將當(dāng)前時間更新到examinfo表中id=14的記錄的endtime字段中去.

  關(guān)閉事件任務(wù)

  alter event e_test ON
  COMPLETION PRESERVE DISABLE;

  開戶事件任務(wù)
  alter event e_test ON
  COMPLETION PRESERVE ENABLE;