创建定时器: create event myevent on schedule every 30 second starts current_timestamp do update manager set b_hostState=0 where now()-interval 80 second> d_lastUpdate;
创建触发器: delimiter | create trigger manager_bu before update on manager for each row begin
其实你上面的操作可以不用触发器，直接在update语句里面一步到位了： create event myevent on schedule every 30 second starts current_timestamp do update manager set b_hostState=0,d_lastUpdate=now() where now()-interval 80 second> d_lastUpdate; 正解。
