mysql怎么将下面代码改成每隔一分钟执行一次createeventifnotexistsetest2onscheduleevery1monthstartsDATEADD(DATEADD(DATESUB(CURDATE(),INTERVALDAY(CURDATE())-1DAY),INTERVAL1MONTH),INTERVAL1HOUR)oncompletionpreserv

Question

mysql 怎么将下面代码改成每隔一分钟执行一次
create event if not exists e_test2
on schedule every 1 month starts DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1
DAY),INTERVAL 1 MONTH),INTERVAL 1 HOUR)
on completion preserve
do
UPDATE ajax_chat_vote SET kanduo=0 and panzheng=0 and kankong=0 where id=1;
还有上面的这句话是什么意思?
on schedule every 1 month starts DATE_ADD(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1
DAY),INTERVAL 1 MONTH),INTERVAL 1 HOUR)
求逐句翻译这句话

Answer 1

sleep(60)；