我想用event每天凌晨 00:01:00 的时候自动执行一段sqluse DBName;
CREATE EVENT e_insert_bak
ON SCHEDULE
EVERY 24 HOUR
STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:01:00')
DO
INSERT INTO a VALUES (CURRENT_TIMESTAMP);
INSERT INTO b VALUES (CURRENT_TIMESTAMP);
请帮忙看看这一段event代码有什么问题?
CREATE EVENT e_insert_bak
ON SCHEDULE
EVERY 24 HOUR
STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:01:00')
DO
INSERT INTO a VALUES (CURRENT_TIMESTAMP);
INSERT INTO b VALUES (CURRENT_TIMESTAMP);
请帮忙看看这一段event代码有什么问题?
CREATE EVENT e_insert_bak
ON SCHEDULE
EVERY 24 HOUR
STARTS concat(date_format(now(),'%Y-%m-%d'),' 00:01:00')
DO
INSERT INTO a VALUES (CURRENT_TIMESTAMP);
INSERT INTO b VALUES (CURRENT_TIMESTAMP);
||delimiter ;