mysql定时任务怎么设置

#event开关
event_scheduler=ON

CREATE
    [DEFINER = { user | CURRENT_USER }]
    EVENT
    [IF NOT EXISTS]
    event_name
    ON SCHEDULE schedule
    [ON COMPLETION [NOT] PRESERVE]
    [ENABLE | DISABLE | DISABLE ON SLAVE]
    [COMMENT 'comment']
    DO event_body

    AT timestamp [+ INTERVAL interval] ...
  | EVERY interval
    [STARTS timestamp [+ INTERVAL interval] ...]
    [ENDS timestamp [+ INTERVAL interval] ...]

  quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
              WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
              DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}

/*创建简单的任务，每分钟执行一次，从一个表取数据插入到另一个表，此处为简单例子*/  
    CREATE EVENT MyEvent  
    ON SCHEDULE EVERY 1 MINUTE   
    DO  
    INSERT INTO 表1 (字段1,字段1,字段1,字段1,字段1)  select 字段1,字段1,字段1,字段1,字段1 from 表2 where id = 510;