show variables like '%sche%';

  將事件計(jì)劃開(kāi)啟

  set global event_scheduler =1;

  創(chuàng)建存儲(chǔ)過(guò)程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í)行存儲(chǔ)過(guò)程test,將當(dāng)前時(shí)間更新到examinfo表中id=14的記錄的endtime字段中去.

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

  alter event e_test ON
  COMPLETION PRESERVE DISABLE;

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